BIP – Query to get Job Profile Details
SELECT pjf.job_code
,hpb.profile_code
,hpt.description profile_desc
,hpt.summary
,hpeiv.DESCRIPTION
,hpeiv.RESPONSIBILITIES
,hpeiv.QUALIFICATIONS
FROM HRT_PROFILE_ITEMS hpi
,HRT_PROFILES_B hpb
,HRT_PROFILES_TL hpt
,HRT_PROFILE_RELATIONS hpr
,HRT_PROFILE_EXTRA_INFO_VL hpeiv
,PER_JOBS_F pjf
WHERE hpi.profile_id = hpb.profile_id
AND hpb.profile_usage_code = 'M'
AND hpi.profile_id = hpr.profile_id
AND hpi.profile_id = hpt.profile_id
AND hpi.profile_id = hpeiv.profile_id
AND pjf.job_id = hpr.object_id
AND trunc(sysdate) between pjf.effective_start_date and pjf.effective_end_Date
AND pjf.job_code= '1099'
AND hpt.language = 'US'