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_PAYACT_PKG dependencies on PER_ALL_ASSIGNMENTS_F

Line 683: l_location_id per_all_assignments_f.location_id%TYPE;

679: ass_flag varchar2(2);
680:
681: --
682: l_payroll_id pay_payroll_actions.payroll_id%TYPE;
683: l_location_id per_all_assignments_f.location_id%TYPE;
684: l_consolidation_set_id pay_payroll_actions.consolidation_set_id%TYPE;
685: l_tax_unit_id pay_assignment_actions.tax_unit_id%TYPE;
686: l_person_id per_all_assignments_f.person_id%TYPE;
687: l_business_group_id per_all_assignments_f.business_group_id%TYPE;

Line 686: l_person_id per_all_assignments_f.person_id%TYPE;

682: l_payroll_id pay_payroll_actions.payroll_id%TYPE;
683: l_location_id per_all_assignments_f.location_id%TYPE;
684: l_consolidation_set_id pay_payroll_actions.consolidation_set_id%TYPE;
685: l_tax_unit_id pay_assignment_actions.tax_unit_id%TYPE;
686: l_person_id per_all_assignments_f.person_id%TYPE;
687: l_business_group_id per_all_assignments_f.business_group_id%TYPE;
688: l_organization_id per_all_assignments_f.organization_id%TYPE;
689: l_start_date pay_payroll_actions.effective_date%TYPE;
690: l_effective_date pay_payroll_actions.effective_date%TYPE;

Line 687: l_business_group_id per_all_assignments_f.business_group_id%TYPE;

683: l_location_id per_all_assignments_f.location_id%TYPE;
684: l_consolidation_set_id pay_payroll_actions.consolidation_set_id%TYPE;
685: l_tax_unit_id pay_assignment_actions.tax_unit_id%TYPE;
686: l_person_id per_all_assignments_f.person_id%TYPE;
687: l_business_group_id per_all_assignments_f.business_group_id%TYPE;
688: l_organization_id per_all_assignments_f.organization_id%TYPE;
689: l_start_date pay_payroll_actions.effective_date%TYPE;
690: l_effective_date pay_payroll_actions.effective_date%TYPE;
691:

Line 688: l_organization_id per_all_assignments_f.organization_id%TYPE;

684: l_consolidation_set_id pay_payroll_actions.consolidation_set_id%TYPE;
685: l_tax_unit_id pay_assignment_actions.tax_unit_id%TYPE;
686: l_person_id per_all_assignments_f.person_id%TYPE;
687: l_business_group_id per_all_assignments_f.business_group_id%TYPE;
688: l_organization_id per_all_assignments_f.organization_id%TYPE;
689: l_start_date pay_payroll_actions.effective_date%TYPE;
690: l_effective_date pay_payroll_actions.effective_date%TYPE;
691:
692: -- algorithm is quite similar to the other process cases,

Line 1308: per_all_assignments_f paf,

1304: from hr_all_organization_units hou, /* Assignment Org */
1305: hr_all_organization_units hou1,/* Tax Unit */
1306: hr_locations_all loc,
1307: per_all_people_f ppf,
1308: per_all_assignments_f paf,
1309: pay_assignment_actions paa, /* PYUGEN assignment action */
1310: pay_payroll_actions ppa, /* PYUGEN payroll action id */
1311: pay_assignment_actions paa1, /*For Sorting */
1312: pay_action_interlocks pai,

Line 1319: from per_all_assignments_f paf1

1315: and paa.payroll_action_id = ppa.payroll_action_id
1316: and paf.assignment_id = paa.assignment_id
1317: and paf.effective_start_date =
1318: (select max(paf1.effective_start_date)
1319: from per_all_assignments_f paf1
1320: where paf1.assignment_id = paf.assignment_id
1321: and paf1.effective_start_date <= ppa.effective_date
1322: and paf1.effective_end_date >= ppa.start_date
1323: )