APPS.PER_JP_EMPDET_ARCHIVE_PKG dependencies on HR_ALL_POSITIONS_F_VL

Line 1719: hr_all_positions_f_vl hap,

1715: and pa_ee.effective_start_date = pa_etd.effective_end_date + 1)
1716: order by pa_etd.effective_start_date) etd_v,
1717: hr_organization_units hou,
1718: per_jobs_vl pj,
1719: hr_all_positions_f_vl hap,
1720: per_grades_vl pg
1721: where etd_v.etd_rownum = std_v.std_rownum
1722: and hou.organization_id = std_v.organization_id
1723: and pj.job_id (+) = std_v.job_id

Line 1815: hr_all_positions_f_vl hap

1811: and pa_ee.effective_start_date = pa_etd.effective_end_date + 1)
1812: order by pa_etd.effective_start_date) etd_v,
1813: hr_organization_units hou,
1814: per_jobs_vl pj,
1815: hr_all_positions_f_vl hap
1816: where etd_v.etd_rownum = std_v.std_rownum
1817: and hou.organization_id = std_v.organization_id
1818: and pj.job_id (+) = std_v.job_id
1819: and hap.position_id (+) = std_v.position_id;