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

Line 827: ,c_assignment_id per_all_assignments_f.assignment_id%type

823: ,c_start_person per_all_people_f.person_id%type
824: ,c_end_person per_all_people_f.person_id%type
825: ,c_employee_type per_all_people_f.current_employee_flag%type
826: ,c_business_group_id hr_all_organization_units.organization_id%type
827: ,c_assignment_id per_all_assignments_f.assignment_id%type
828: ,c_archive_start_date date
829: ,c_archive_end_date date
830: ) is
831: select paa.assignment_action_id,

Line 876: ,c_assignment_id per_all_assignments_f.assignment_id%type

872: ,c_start_person per_all_people_f.person_id%type
873: ,c_end_person per_all_people_f.person_id%type
874: ,c_employee_type per_all_people_f.current_employee_flag%type
875: ,c_business_group_id hr_all_organization_units.organization_id%type
876: ,c_assignment_id per_all_assignments_f.assignment_id%type
877: ,c_period_end_date date
878: ,c_pact_id pay_payroll_actions.payroll_action_id%type
879: ) is
880: select paa.assignment_action_id,

Line 1787: FROM per_all_assignments_f paaf,

1783: where assignment has payroll attached to it for few months but is not attached at the end of year*/
1784: CURSOR c_get_payroll_name(c_assignment_id number,c_end_date date, c_start_date date)
1785: IS
1786: SELECT paaf.payroll_id, pay.payroll_name
1787: FROM per_all_assignments_f paaf,
1788: pay_payrolls_f pay
1789: WHERE paaf.assignment_id = c_assignment_id
1790: and paaf.effective_end_date = (select max(effective_end_date)
1791: From per_assignments_f iipaf