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 340: ,per_periods_of_service ppos

336: ,org.name ORGANIZATION
337: ,loc.location_code location
338: FROM per_people_f ppf
339: ,per_assignments_f paf
340: ,per_periods_of_service ppos
341: ,hr_soft_coding_keyflex hsck
342: ,hr_organization_units hou
343: ,hr_organization_units org
344: ,hr_locations loc

Line 369: ,per_periods_of_service ppos

365: FROM per_positions pp
366: ,per_jobs pj
367: ,per_people_f ppf
368: ,per_assignments_f paf
369: ,per_periods_of_service ppos
370: WHERE ppf.business_group_id = p_bus_grp_id
371: AND ppf.employee_number = p_employee_number
372: AND ppf.person_id = paf.person_id
373: AND ppos.period_of_service_id = paf.period_of_service_id

Line 409: ,per_periods_of_service ppos

405: ,pay_input_values_f piv
406: ,pay_assignment_actions paa
407: ,pay_run_results prr
408: ,pay_run_result_values prrv
409: ,per_periods_of_service ppos
410: ,pay_element_classifications pec
411: WHERE paf.business_group_id = p_bus_grp_id
412: AND ppf.employee_number = p_employee_number
413: AND ppf.person_id = paf.person_id

Line 462: ,per_periods_of_service ppos

458: FROM pay_assignment_actions paa
459: ,pay_payroll_actions ppa
460: ,per_people_f ppf
461: ,per_assignments_f paf
462: ,per_periods_of_service ppos
463: WHERE ppf.employee_number = p_employee_number
464: AND ppf.person_id = paf.person_id
465: AND paf.period_of_service_id = ppos.period_of_service_id
466: AND ppf.person_id = ppos.person_id

Line 498: FROM per_periods_of_service pos

494: ,p_bus_grp_id NUMBER
495: ,p_term_date DATE )
496: IS
497: SELECT max(last_day(pos.last_standard_process_date))
498: FROM per_periods_of_service pos
499: ,per_people_f ppf
500: WHERE ppf.employee_number = p_employee_number
501: AND ppf.person_id = pos.person_id
502: AND ppf.business_group_id = p_bus_grp_id

Line 518: ,per_periods_of_service ppos

514: FROM pay_assignment_actions paa
515: ,pay_payroll_actions ppa
516: ,per_people_f ppf
517: ,per_assignments_f paf
518: ,per_periods_of_service ppos
519: WHERE ppf.employee_number = p_employee_number
520: AND ppf.person_id = paf.person_id
521: AND paf.period_of_service_id = ppos.period_of_service_id
522: AND ppf.person_id = ppos.person_id

Line 550: ,per_periods_of_service ppos

546: FROM pay_assignment_actions paa
547: ,pay_payroll_actions ppa
548: ,per_people_f ppf
549: ,per_assignments_f paf
550: ,per_periods_of_service ppos
551: WHERE ppf.employee_number = p_employee_number
552: AND ppf.person_id = paf.person_id
553: AND paf.period_of_service_id = ppos.period_of_service_id
554: AND ppf.person_id = ppos.person_id

Line 583: ,per_periods_of_service ppos

579: FROM pay_assignment_actions paa
580: ,pay_payroll_actions ppa
581: ,per_people_f ppf
582: ,per_assignments_f paf
583: ,per_periods_of_service ppos
584: WHERE ppf.employee_number = p_employee_number
585: AND ppf.person_id = paf.person_id
586: AND paf.period_of_service_id = ppos.period_of_service_id
587: AND ppf.person_id = ppos.person_id

Line 627: ,per_periods_of_service ppos

623: ,pay_assignment_actions paa
624: ,pay_payroll_actions ppa
625: ,pay_run_results prr
626: ,pay_run_result_values prrv
627: ,per_periods_of_service ppos
628: WHERE paf.business_group_id = p_bus_grp_id
629: AND ppf.employee_number = p_employee_number
630: AND ppf.person_id = paf.person_id
631: AND paf.period_of_service_id = ppos.period_of_service_id

Line 682: ,per_periods_of_service ppos

678: ,pay_assignment_actions paa
679: ,pay_payroll_actions ppa
680: ,pay_run_results prr
681: ,pay_run_result_values prrv
682: ,per_periods_of_service ppos
683: WHERE paf.business_group_id = p_bus_grp_id
684: AND ppf.employee_number = p_employee_number
685: AND ppf.person_id = paf.person_id
686: AND paf.period_of_service_id = ppos.period_of_service_id

Line 734: ,per_periods_of_service ppos

730: ,pay_input_values_f piv
731: ,pay_assignment_actions paa
732: ,pay_run_results prr
733: ,pay_run_result_values prrv
734: ,per_periods_of_service ppos
735: ,pay_element_classifications pec
736: WHERE paf.business_group_id = p_bus_grp_id
737: AND ppf.employee_number = p_employee_number
738: AND ppf.person_id = paf.person_id

Line 790: ,per_periods_of_service ppos

786: ,pay_input_values_f piv
787: ,pay_assignment_actions paa
788: ,pay_run_results prr
789: ,pay_run_result_values prrv
790: ,per_periods_of_service ppos
791: ,pay_element_classifications pec
792: WHERE paf.business_group_id = p_bus_grp_id
793: AND ppf.employee_number = p_employee_number
794: AND ppf.person_id = paf.person_id

Line 842: ,per_periods_of_service ppos

838: ,pay_input_values_f piv
839: ,pay_assignment_actions paa
840: ,pay_run_results prr
841: ,pay_run_result_values prrv
842: ,per_periods_of_service ppos
843: ,pay_element_classifications pec
844: WHERE paf.business_group_id = p_bus_grp_id
845: AND ppf.employee_number = p_employee_number
846: AND ppf.person_id = paf.person_id

Line 891: ,per_periods_of_service ppos

887: ,pay_input_values_f piv
888: ,pay_assignment_actions paa
889: ,pay_run_results prr
890: ,pay_run_result_values prrv
891: ,per_periods_of_service ppos
892: ,pay_element_classifications pec
893: WHERE ppf.business_group_id = p_bus_grp_id
894: AND ppf.employee_number = p_employee_number
895: AND ppf.person_id = paf.person_id

Line 955: ,per_periods_of_service ppos

951: ,pay_assignment_actions paa
952: -- ,pay_element_entries_f peef-- Added as a part of bug fix 4774108
953: ,pay_run_results prr
954: ,pay_run_result_values prrv
955: ,per_periods_of_service ppos
956: ,pay_element_classifications pec
957: WHERE paf.business_group_id = p_bus_grp_id
958: AND ppf.employee_number = p_employee_number
959: AND ppf.person_id = paf.person_id

Line 995: ,per_periods_of_service ppos

991: , pbt.balance_name description
992: FROM per_assignments_f paf
993: ,per_people_f ppf
994: ,pay_assignment_actions paa
995: ,per_periods_of_service ppos
996: ,pay_balance_types pbt
997: ,pay_balance_dimensions pbd
998: ,pay_defined_balances pdb
999: WHERE paf.business_group_id = p_bus_grp_id

Line 1037: ,per_periods_of_service ppos

1033: ,pay_payroll_actions ppa
1034: ,pay_assignment_actions paa
1035: ,per_people_f ppf
1036: ,per_assignments_f paf
1037: ,per_periods_of_service ppos
1038: WHERE ppp.assignment_action_id = pci.locking_action_id
1039: AND ppp.personal_payment_method_id = ppm.personal_payment_method_id (+)
1040: AND ppp.org_payment_method_id = pop.org_payment_method_id
1041: AND ppm.external_account_id = pea.external_account_id (+)

Line 1074: ,per_periods_of_service ppos

1070: , pbt.balance_name description
1071: FROM per_assignments_f paf
1072: ,per_people_f ppf
1073: ,pay_assignment_actions paa
1074: ,per_periods_of_service ppos
1075: ,pay_balance_types pbt
1076: ,pay_balance_dimensions pbd
1077: ,pay_defined_balances pdb
1078: WHERE paf.business_group_id = p_bus_grp_id

Line 1099: l_process_date per_periods_of_service.last_standard_process_date%TYPE;

1095: --
1096: --
1097: --
1098: l_final_report_info hr_organization_information.org_information6%TYPE; -- Bug 6772976 addition
1099: l_process_date per_periods_of_service.last_standard_process_date%TYPE;
1100: l_max_payment_action_id pay_assignment_actions.assignment_action_id%TYPE;
1101: --
1102: l_procedure VARCHAR2(250);
1103: l_message VARCHAR2(250);