DBA Data[Home] [Help]

APPS.PAY_GB_HR_HELPDESK dependencies on STANDARD

Line 330: ,to_char(pps.last_standard_process_date,'YYYY-MM-DD') last_standard_process_date

326: ,to_char(pps.date_start,'YYYY-MM-DD') date_start
327: ,to_char(pps.accepted_termination_date,'YYYY-MM-DD') accepted_termination_date
328: ,to_char(pps.actual_termination_date,'YYYY-MM-DD') actual_termination_date
329: ,to_char(pps.final_process_date,'YYYY-MM-DD') final_process_date
330: ,to_char(pps.last_standard_process_date,'YYYY-MM-DD') last_standard_process_date
331: ,leaving_reason
332: from per_periods_of_service pps
333: where pps.person_id = p_person_id
334: and ( ( p_employee_number is null )

Line 347: ,to_char(ppp.last_standard_process_date,'YYYY-MM-DD') last_standard_process_date

343: ,to_char(ppp.date_start,'YYYY-MM-DD') date_start
344: ,null accepted_termination_date
345: ,to_char(ppp.actual_termination_date,'YYYY-MM-DD') actual_termination_date
346: ,to_char(ppp.final_process_date,'YYYY-MM-DD') final_process_date
347: ,to_char(ppp.last_standard_process_date,'YYYY-MM-DD') last_standard_process_date
348: ,termination_reason leaving_reason
349: from per_periods_of_placement ppp
350: where ppp.person_id = p_person_id
351: and (ppp.date_start = (