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

Line 547: l_location_id per_all_assignments_f.location_id%TYPE;

543: l_action_insert varchar2(1);
544: l_void_action varchar2(1);
545:
546: l_payroll_id pay_payroll_actions.payroll_id%TYPE;
547: l_location_id per_all_assignments_f.location_id%TYPE;
548: l_consolidation_set_id pay_payroll_actions.consolidation_set_id%TYPE;
549: l_tax_unit_id pay_assignment_actions.tax_unit_id%TYPE;
550: l_person_id per_all_assignments_f.person_id%TYPE;
551: l_business_group_id per_all_assignments_f.business_group_id%TYPE;

Line 550: l_person_id per_all_assignments_f.person_id%TYPE;

546: l_payroll_id pay_payroll_actions.payroll_id%TYPE;
547: l_location_id per_all_assignments_f.location_id%TYPE;
548: l_consolidation_set_id pay_payroll_actions.consolidation_set_id%TYPE;
549: l_tax_unit_id pay_assignment_actions.tax_unit_id%TYPE;
550: l_person_id per_all_assignments_f.person_id%TYPE;
551: l_business_group_id per_all_assignments_f.business_group_id%TYPE;
552: l_organization_id per_all_assignments_f.organization_id%TYPE;
553: l_assignment_set_id hr_assignment_set_amendments.assignment_set_id%TYPE;
554: cp_start_date pay_payroll_actions.effective_date%TYPE;

Line 551: l_business_group_id per_all_assignments_f.business_group_id%TYPE;

547: l_location_id per_all_assignments_f.location_id%TYPE;
548: l_consolidation_set_id pay_payroll_actions.consolidation_set_id%TYPE;
549: l_tax_unit_id pay_assignment_actions.tax_unit_id%TYPE;
550: l_person_id per_all_assignments_f.person_id%TYPE;
551: l_business_group_id per_all_assignments_f.business_group_id%TYPE;
552: l_organization_id per_all_assignments_f.organization_id%TYPE;
553: l_assignment_set_id hr_assignment_set_amendments.assignment_set_id%TYPE;
554: cp_start_date pay_payroll_actions.effective_date%TYPE;
555: cp_effective_date pay_payroll_actions.effective_date%TYPE;

Line 552: l_organization_id per_all_assignments_f.organization_id%TYPE;

548: l_consolidation_set_id pay_payroll_actions.consolidation_set_id%TYPE;
549: l_tax_unit_id pay_assignment_actions.tax_unit_id%TYPE;
550: l_person_id per_all_assignments_f.person_id%TYPE;
551: l_business_group_id per_all_assignments_f.business_group_id%TYPE;
552: l_organization_id per_all_assignments_f.organization_id%TYPE;
553: l_assignment_set_id hr_assignment_set_amendments.assignment_set_id%TYPE;
554: cp_start_date pay_payroll_actions.effective_date%TYPE;
555: cp_effective_date pay_payroll_actions.effective_date%TYPE;
556:

Line 1328: per_all_assignments_f paf

1324: and hou.organization_id = paf.organization_id
1325: and rownum = 1),
1326: (select distinct ppf.full_name
1327: from per_all_people_f ppf,
1328: per_all_assignments_f paf
1329: where paf.assignment_id = paa.assignment_id
1330: and ppf.person_id = paf.person_id
1331: and ppa.effective_date between
1332: paf.effective_start_date and paf.effective_end_date