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 680: l_location_id per_all_assignments_f.location_id%TYPE;

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

Line 683: l_person_id per_all_assignments_f.person_id%TYPE;

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

Line 684: l_business_group_id per_all_assignments_f.business_group_id%TYPE;

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

Line 685: l_organization_id per_all_assignments_f.organization_id%TYPE;

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

Line 1305: per_all_assignments_f paf,

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

Line 1316: from per_all_assignments_f paf1

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