APPS.HR_PERSON_RECORD dependencies on PER_PERIODS_OF_SERVICE

Line 1511: from per_periods_of_service pps

1507: ,to_char(pps.actual_termination_date,'YYYY-MM-DD') actual_termination_date
1508: ,to_char(pps.final_process_date,'YYYY-MM-DD') final_process_date
1509: ,to_char(pps.last_standard_process_date,'YYYY-MM-DD') last_standard_process_date
1510: ,leaving_reason
1511: from per_periods_of_service pps
1512: where pps.person_id = p_person_id
1513: and ( ( p_employee_number is null )
1514: or ( p_employee_number is not null
1515: and pps.date_start = (

Line 1517: from per_periods_of_service pps1

1513: and ( ( p_employee_number is null )
1514: or ( p_employee_number is not null
1515: and pps.date_start = (
1516: select max(pps1.date_start)
1517: from per_periods_of_service pps1
1518: where pps1.person_id = p_person_id
1519: and pps1.date_start <= to_date(p_effective_end_date,'YYYY-MM-DD') ) ) );
1520: cursor csr_periods_of_placement(p_person_id number, p_employee_number number, p_effective_end_date varchar2) is
1521: select null adjusted_svc_date