eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PAY_IN_TERM_RPRT_GEN_PKG dependencies on PER_PERIODS_OF_SERVICE

Line 250: ,per_periods_of_service ppos

246: (ppos.actual_termination_date, ppos.date_start)/12))) ||' Days' los
247: ,hou.name department
248: FROM per_people_f ppf
249: ,per_assignments_f paf
250: ,per_periods_of_service ppos
251: ,hr_soft_coding_keyflex hsck
252: ,hr_organization_units hou
253: WHERE ppf.business_group_id = p_bus_grp_id
254: AND ppf.employee_number = p_employee_number

Line 275: ,per_periods_of_service ppos

271: FROM per_positions pp
272: ,per_jobs pj
273: ,per_people_f ppf
274: ,per_assignments_f paf
275: ,per_periods_of_service ppos
276: WHERE ppf.business_group_id = p_bus_grp_id
277: AND ppf.employee_number = p_employee_number
278: AND ppf.person_id = paf.person_id
279: AND ppos.period_of_service_id = paf.period_of_service_id

Line 314: ,per_periods_of_service ppos

310: ,pay_input_values_f piv
311: ,pay_assignment_actions paa
312: ,pay_run_results prr
313: ,pay_run_result_values prrv
314: ,per_periods_of_service ppos
315: ,pay_element_classifications pec
316: WHERE paf.business_group_id = p_bus_grp_id
317: AND ppf.employee_number = p_employee_number
318: AND ppf.person_id = paf.person_id

Line 366: ,per_periods_of_service ppos

362: FROM pay_assignment_actions paa
363: ,pay_payroll_actions ppa
364: ,per_people_f ppf
365: ,per_assignments_f paf
366: ,per_periods_of_service ppos
367: WHERE ppf.employee_number = p_employee_number
368: AND ppf.person_id = paf.person_id
369: AND paf.period_of_service_id = ppos.period_of_service_id
370: AND ppf.person_id = ppos.person_id

Line 402: FROM per_periods_of_service pos

398: ,p_bus_grp_id NUMBER
399: ,p_term_date DATE )
400: IS
401: SELECT max(last_day(pos.last_standard_process_date))
402: FROM per_periods_of_service pos
403: ,per_people_f ppf
404: WHERE ppf.employee_number = p_employee_number
405: AND ppf.person_id = pos.person_id
406: AND ppf.business_group_id = p_bus_grp_id

Line 422: ,per_periods_of_service ppos

418: FROM pay_assignment_actions paa
419: ,pay_payroll_actions ppa
420: ,per_people_f ppf
421: ,per_assignments_f paf
422: ,per_periods_of_service ppos
423: WHERE ppf.employee_number = p_employee_number
424: AND ppf.person_id = paf.person_id
425: AND paf.period_of_service_id = ppos.period_of_service_id
426: AND ppf.person_id = ppos.person_id

Line 454: ,per_periods_of_service ppos

450: FROM pay_assignment_actions paa
451: ,pay_payroll_actions ppa
452: ,per_people_f ppf
453: ,per_assignments_f paf
454: ,per_periods_of_service ppos
455: WHERE ppf.employee_number = p_employee_number
456: AND ppf.person_id = paf.person_id
457: AND paf.period_of_service_id = ppos.period_of_service_id
458: AND ppf.person_id = ppos.person_id

Line 487: ,per_periods_of_service ppos

483: FROM pay_assignment_actions paa
484: ,pay_payroll_actions ppa
485: ,per_people_f ppf
486: ,per_assignments_f paf
487: ,per_periods_of_service ppos
488: WHERE ppf.employee_number = p_employee_number
489: AND ppf.person_id = paf.person_id
490: AND paf.period_of_service_id = ppos.period_of_service_id
491: AND ppf.person_id = ppos.person_id

Line 531: ,per_periods_of_service ppos

527: ,pay_assignment_actions paa
528: ,pay_payroll_actions ppa
529: ,pay_run_results prr
530: ,pay_run_result_values prrv
531: ,per_periods_of_service ppos
532: WHERE paf.business_group_id = p_bus_grp_id
533: AND ppf.employee_number = p_employee_number
534: AND ppf.person_id = paf.person_id
535: AND paf.period_of_service_id = ppos.period_of_service_id

Line 586: ,per_periods_of_service ppos

582: ,pay_assignment_actions paa
583: ,pay_payroll_actions ppa
584: ,pay_run_results prr
585: ,pay_run_result_values prrv
586: ,per_periods_of_service ppos
587: WHERE paf.business_group_id = p_bus_grp_id
588: AND ppf.employee_number = p_employee_number
589: AND ppf.person_id = paf.person_id
590: AND paf.period_of_service_id = ppos.period_of_service_id

Line 638: ,per_periods_of_service ppos

634: ,pay_input_values_f piv
635: ,pay_assignment_actions paa
636: ,pay_run_results prr
637: ,pay_run_result_values prrv
638: ,per_periods_of_service ppos
639: ,pay_element_classifications pec
640: WHERE paf.business_group_id = p_bus_grp_id
641: AND ppf.employee_number = p_employee_number
642: AND ppf.person_id = paf.person_id

Line 694: ,per_periods_of_service ppos

690: ,pay_input_values_f piv
691: ,pay_assignment_actions paa
692: ,pay_run_results prr
693: ,pay_run_result_values prrv
694: ,per_periods_of_service ppos
695: ,pay_element_classifications pec
696: WHERE paf.business_group_id = p_bus_grp_id
697: AND ppf.employee_number = p_employee_number
698: AND ppf.person_id = paf.person_id

Line 746: ,per_periods_of_service ppos

742: ,pay_input_values_f piv
743: ,pay_assignment_actions paa
744: ,pay_run_results prr
745: ,pay_run_result_values prrv
746: ,per_periods_of_service ppos
747: ,pay_element_classifications pec
748: WHERE paf.business_group_id = p_bus_grp_id
749: AND ppf.employee_number = p_employee_number
750: AND ppf.person_id = paf.person_id

Line 794: ,per_periods_of_service ppos

790: ,pay_input_values_f piv
791: ,pay_assignment_actions paa
792: ,pay_run_results prr
793: ,pay_run_result_values prrv
794: ,per_periods_of_service ppos
795: ,pay_element_classifications pec
796: WHERE ppf.business_group_id = p_bus_grp_id
797: AND ppf.employee_number = p_employee_number
798: AND ppf.person_id = paf.person_id

Line 858: ,per_periods_of_service ppos

854: ,pay_assignment_actions paa
855: -- ,pay_element_entries_f peef-- Added as a part of bug fix 4774108
856: ,pay_run_results prr
857: ,pay_run_result_values prrv
858: ,per_periods_of_service ppos
859: ,pay_element_classifications pec
860: WHERE paf.business_group_id = p_bus_grp_id
861: AND ppf.employee_number = p_employee_number
862: AND ppf.person_id = paf.person_id

Line 898: ,per_periods_of_service ppos

894: , pbt.balance_name description
895: FROM per_assignments_f paf
896: ,per_people_f ppf
897: ,pay_assignment_actions paa
898: ,per_periods_of_service ppos
899: ,pay_balance_types pbt
900: ,pay_balance_dimensions pbd
901: ,pay_defined_balances pdb
902: WHERE paf.business_group_id = p_bus_grp_id

Line 940: ,per_periods_of_service ppos

936: ,pay_payroll_actions ppa
937: ,pay_assignment_actions paa
938: ,per_people_f ppf
939: ,per_assignments_f paf
940: ,per_periods_of_service ppos
941: WHERE ppp.assignment_action_id = pci.locking_action_id
942: AND ppp.personal_payment_method_id = ppm.personal_payment_method_id (+)
943: AND ppp.org_payment_method_id = pop.org_payment_method_id
944: AND ppm.external_account_id = pea.external_account_id (+)

Line 977: ,per_periods_of_service ppos

973: , pbt.balance_name description
974: FROM per_assignments_f paf
975: ,per_people_f ppf
976: ,pay_assignment_actions paa
977: ,per_periods_of_service ppos
978: ,pay_balance_types pbt
979: ,pay_balance_dimensions pbd
980: ,pay_defined_balances pdb
981: WHERE paf.business_group_id = p_bus_grp_id

Line 1002: l_process_date per_periods_of_service.last_standard_process_date%TYPE;

998: --
999: --
1000: --
1001: l_final_report_info hr_organization_information.org_information6%TYPE; -- Bug 6772976 addition
1002: l_process_date per_periods_of_service.last_standard_process_date%TYPE;
1003: l_max_payment_action_id pay_assignment_actions.assignment_action_id%TYPE;
1004: --
1005: l_procedure VARCHAR2(250);
1006: l_message VARCHAR2(250);