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 621: ,c_assignment_id per_all_assignments_f.assignment_id%type

617: ,c_start_person per_all_people_f.person_id%type
618: ,c_end_person per_all_people_f.person_id%type
619: ,c_employee_type per_all_people_f.current_employee_flag%type
620: ,c_business_group_id hr_all_organization_units.organization_id%type
621: ,c_assignment_id per_all_assignments_f.assignment_id%type
622: ,c_archive_start_date date
623: ,c_archive_end_date date
624: ) is
625: select paa.assignment_action_id,

Line 670: ,c_assignment_id per_all_assignments_f.assignment_id%type

666: ,c_start_person per_all_people_f.person_id%type
667: ,c_end_person per_all_people_f.person_id%type
668: ,c_employee_type per_all_people_f.current_employee_flag%type
669: ,c_business_group_id hr_all_organization_units.organization_id%type
670: ,c_assignment_id per_all_assignments_f.assignment_id%type
671: ,c_period_end_date date
672: ,c_pact_id pay_payroll_actions.payroll_action_id%type
673: ) is
674: select paa.assignment_action_id,

Line 1615: FROM per_all_assignments_f paaf,

1611: c_start_date date,
1612: c_end_date date)
1613: IS
1614: SELECT paaf.payroll_id, pay.payroll_name
1615: FROM per_all_assignments_f paaf,
1616: pay_payrolls_f pay
1617: WHERE paaf.assignment_id = c_assignment_id
1618: and paaf.effective_end_date = (select max(effective_end_date)
1619: From per_assignments_f iipaf