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

Line 470: l_location_id per_all_assignments_f.location_id%TYPE;

466: l_asg_act_id NUMBER;
467: l_action_insert VARCHAR2(1);
468: l_void_action VARCHAR2(1);
469: l_payroll_id pay_payroll_actions.payroll_id%TYPE;
470: l_location_id per_all_assignments_f.location_id%TYPE;
471: l_consolidation_set_id pay_payroll_actions.consolidation_set_id%TYPE;
472: l_tax_unit_id pay_assignment_actions.tax_unit_id%TYPE;
473: l_person_id per_all_assignments_f.person_id%TYPE;
474: l_business_group_id per_all_assignments_f.business_group_id%TYPE;

Line 473: l_person_id per_all_assignments_f.person_id%TYPE;

469: l_payroll_id pay_payroll_actions.payroll_id%TYPE;
470: l_location_id per_all_assignments_f.location_id%TYPE;
471: l_consolidation_set_id pay_payroll_actions.consolidation_set_id%TYPE;
472: l_tax_unit_id pay_assignment_actions.tax_unit_id%TYPE;
473: l_person_id per_all_assignments_f.person_id%TYPE;
474: l_business_group_id per_all_assignments_f.business_group_id%TYPE;
475: l_organization_id per_all_assignments_f.organization_id%TYPE;
476: l_assignment_set_id hr_assignment_set_amendments.assignment_set_id%TYPE;
477: cp_start_date pay_payroll_actions.effective_date%TYPE;

Line 474: l_business_group_id per_all_assignments_f.business_group_id%TYPE;

470: l_location_id per_all_assignments_f.location_id%TYPE;
471: l_consolidation_set_id pay_payroll_actions.consolidation_set_id%TYPE;
472: l_tax_unit_id pay_assignment_actions.tax_unit_id%TYPE;
473: l_person_id per_all_assignments_f.person_id%TYPE;
474: l_business_group_id per_all_assignments_f.business_group_id%TYPE;
475: l_organization_id per_all_assignments_f.organization_id%TYPE;
476: l_assignment_set_id hr_assignment_set_amendments.assignment_set_id%TYPE;
477: cp_start_date pay_payroll_actions.effective_date%TYPE;
478: cp_effective_date pay_payroll_actions.effective_date%TYPE;

Line 475: l_organization_id per_all_assignments_f.organization_id%TYPE;

471: l_consolidation_set_id pay_payroll_actions.consolidation_set_id%TYPE;
472: l_tax_unit_id pay_assignment_actions.tax_unit_id%TYPE;
473: l_person_id per_all_assignments_f.person_id%TYPE;
474: l_business_group_id per_all_assignments_f.business_group_id%TYPE;
475: l_organization_id per_all_assignments_f.organization_id%TYPE;
476: l_assignment_set_id hr_assignment_set_amendments.assignment_set_id%TYPE;
477: cp_start_date pay_payroll_actions.effective_date%TYPE;
478: cp_effective_date pay_payroll_actions.effective_date%TYPE;
479: l_run_eff_date DATE;

Line 1636: FROM per_all_assignments_f paf

1632: IF c_option_name = 'EMP_NAME' Then
1633: hr_utility.set_location ('Entering '||l_proc_name ,15);
1634: SELECT ppf.full_name
1635: INTO return_val
1636: FROM per_all_assignments_f paf
1637: ,per_all_people_f ppf
1638: WHERE paf.person_id = ppf.person_id
1639: AND c_effective_date BETWEEN
1640: paf.effective_start_date AND paf.effective_end_date

Line 1649: FROM per_all_assignments_f paf

1645: ELSIF c_option_name = 'PAY_NAME' Then
1646: hr_utility.set_location ('Entering '||l_proc_name ,20);
1647: SELECT ppf.payroll_name||' '||papf.full_name
1648: INTO return_val
1649: FROM per_all_assignments_f paf
1650: ,pay_payrolls_f ppf
1651: ,per_all_people_f papf
1652: WHERE paf.payroll_id = ppf.payroll_id
1653: AND c_effective_date BETWEEN