[Home] [Help]
1713: and nvl(pa_ee.position_id,-1) = nvl(pa_etd.position_id,-1)
1714: and nvl(pa_ee.grade_id,-1) = nvl(pa_etd.grade_id,-1)
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
1809: and nvl(pa_ee.job_id,-1) = nvl(pa_etd.job_id,-1)
1810: and nvl(pa_ee.position_id,-1) = nvl(pa_etd.position_id,-1)
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
1832: pa.job_id,
1833: pj.name job_name
1834: from per_periods_of_service ppos,
1835: per_all_assignments_f pa,
1836: hr_organization_units hou,
1837: per_jobs_vl pj
1838: where ppos.person_id = l_person_id
1839: and ppos.date_start < l_hire_date
1840: and ppos.actual_termination_date is not null