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

Line 1000: ,c_assignment_id per_all_assignments_f.assignment_id%type

996: ,c_start_person per_all_people_f.person_id%type
997: ,c_end_person per_all_people_f.person_id%type
998: ,c_employee_type per_all_people_f.current_employee_flag%type
999: ,c_business_group_id hr_all_organization_units.organization_id%type
1000: ,c_assignment_id per_all_assignments_f.assignment_id%type
1001: ,c_archive_start_date date
1002: ,c_archive_end_date date
1003: ) is
1004: select paa.assignment_action_id,

Line 1049: ,c_assignment_id per_all_assignments_f.assignment_id%type

1045: (c_payroll_action_id pay_payroll_actions.payroll_action_id%type
1046: ,c_chunk NUMBER
1047: ,c_employee_type per_all_people_f.current_employee_flag%type
1048: ,c_business_group_id hr_all_organization_units.organization_id%type
1049: ,c_assignment_id per_all_assignments_f.assignment_id%type
1050: ,c_archive_start_date date
1051: ,c_archive_end_date date
1052: ) is
1053: select paa.assignment_action_id,

Line 1100: ,c_assignment_id per_all_assignments_f.assignment_id%type

1096: ,c_start_person per_all_people_f.person_id%type
1097: ,c_end_person per_all_people_f.person_id%type
1098: ,c_employee_type per_all_people_f.current_employee_flag%type
1099: ,c_business_group_id hr_all_organization_units.organization_id%type
1100: ,c_assignment_id per_all_assignments_f.assignment_id%type
1101: ,c_period_end_date date
1102: ,c_pact_id pay_payroll_actions.payroll_action_id%type
1103: ) is
1104: select paa.assignment_action_id,

Line 1144: ,c_assignment_id per_all_assignments_f.assignment_id%type

1140: (c_payroll_action_id pay_payroll_actions.payroll_action_id%type
1141: , c_chunk NUMBER
1142: ,c_employee_type per_all_people_f.current_employee_flag%type
1143: ,c_business_group_id hr_all_organization_units.organization_id%type
1144: ,c_assignment_id per_all_assignments_f.assignment_id%type
1145: ,c_period_end_date date
1146: ,c_pact_id pay_payroll_actions.payroll_action_id%type
1147: ) is
1148: select paa.assignment_action_id,

Line 2814: FROM per_all_assignments_f paaf,

2810: c_start_date date,
2811: c_end_date date)
2812: IS
2813: SELECT paaf.payroll_id, pay.payroll_name
2814: FROM per_all_assignments_f paaf,
2815: pay_payrolls_f pay
2816: WHERE paaf.assignment_id = c_assignment_id
2817: and paaf.effective_end_date = (select max(effective_end_date)
2818: From per_assignments_f iipaf