[Home] [Help]
1525: and to_date(decode(nvl(g_inc_term_flag,'N'),
1526: 'N',to_char(least(nvl(ppos.actual_termination_date,g_effective_date),g_effective_date),'YYYY/MM/DD'),
1527: to_char(nvl(ppos.actual_termination_date,g_effective_date),'YYYY/MM/DD')),'YYYY/MM/DD')
1528: between pp.effective_start_date and pp.effective_end_date) v,
1529: per_jobs_vl pj,
1530: per_addresses pac,
1531: per_phones pphh,
1532: per_phones pphm,
1533: per_phones pphw
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
1722: and hou.organization_id = std_v.organization_id
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
1818: and pj.job_id (+) = std_v.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
1841: and pa.period_of_service_id = ppos.period_of_service_id