[Home] [Help]
224: NULL AS DATE_START,
225: NULL AS ACCEPTED_TERMINATION_DATE,
226: NULL AS ACTUAL_TERMINATION_DATE,
227: NULL AS FINAL_PROCESS_DATE,
228: NULL AS LAST_STANDARD_PROCESS_DATE,
229: NULL AS LEAVING_REASON,
230: TOWN_OF_BIRTH,
231: REGION_OF_BIRTH,
232: COUNTRY_OF_BIRTH,
1505: ,to_char(pps.date_start,'YYYY-MM-DD') date_start
1506: ,to_char(pps.accepted_termination_date,'YYYY-MM-DD') accepted_termination_date
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 )
1522: ,to_char(ppp.date_start,'YYYY-MM-DD') date_start
1523: ,null accepted_termination_date
1524: ,to_char(ppp.actual_termination_date,'YYYY-MM-DD') actual_termination_date
1525: ,to_char(ppp.final_process_date,'YYYY-MM-DD') final_process_date
1526: ,to_char(ppp.last_standard_process_date,'YYYY-MM-DD') last_standard_process_date
1527: ,termination_reason leaving_reason
1528: from per_periods_of_placement ppp
1529: where ppp.person_id = p_person_id
1530: and (ppp.date_start = (
1715: ,p_person(j).person.date_start
1716: ,p_person(j).person.accepted_termination_date
1717: ,p_person(j).person.actual_termination_date
1718: ,p_person(j).person.final_process_date
1719: ,p_person(j).person.last_standard_process_date
1720: ,p_person(j).person.leaving_reason;
1721: close csr_periods_of_placement;
1722:
1723: else
1728: ,p_person(j).person.date_start
1729: ,p_person(j).person.accepted_termination_date
1730: ,p_person(j).person.actual_termination_date
1731: ,p_person(j).person.final_process_date
1732: ,p_person(j).person.last_standard_process_date
1733: ,p_person(j).person.leaving_reason;
1734: close csr_periods_of_service;
1735: end if;
1736: