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

1262: ,c_start_person per_all_people_f.person_id%type
1263: ,c_end_person per_all_people_f.person_id%type
1264: ,c_employee_type per_all_people_f.current_employee_flag%type
1265: ,c_business_group_id hr_all_organization_units.organization_id%type
1266: ,c_assignment_id per_all_assignments_f.assignment_id%type
1267: ,c_archive_start_date date
1268: ,c_archive_end_date date
1269: ) is
1270: select paa.assignment_action_id,

Line 1315: ,c_assignment_id per_all_assignments_f.assignment_id%type

1311: (c_payroll_action_id pay_payroll_actions.payroll_action_id%type
1312: ,c_chunk number
1313: ,c_employee_type per_all_people_f.current_employee_flag%type
1314: ,c_business_group_id hr_all_organization_units.organization_id%type
1315: ,c_assignment_id per_all_assignments_f.assignment_id%type
1316: ,c_archive_start_date date
1317: ,c_archive_end_date date
1318: ) is
1319: select paa.assignment_action_id,

Line 1368: ,c_assignment_id per_all_assignments_f.assignment_id%type

1364: ,c_start_person per_all_people_f.person_id%type
1365: ,c_end_person per_all_people_f.person_id%type
1366: ,c_employee_type per_all_people_f.current_employee_flag%type
1367: ,c_business_group_id hr_all_organization_units.organization_id%type
1368: ,c_assignment_id per_all_assignments_f.assignment_id%type
1369: ,c_period_end_date date
1370: ,c_pact_id pay_payroll_actions.payroll_action_id%type
1371: ) is
1372: select paa.assignment_action_id,

Line 1413: ,c_assignment_id per_all_assignments_f.assignment_id%type

1409: (c_payroll_action_id pay_payroll_actions.payroll_action_id%type
1410: , c_chunk number
1411: ,c_employee_type per_all_people_f.current_employee_flag%type
1412: ,c_business_group_id hr_all_organization_units.organization_id%type
1413: ,c_assignment_id per_all_assignments_f.assignment_id%type
1414: ,c_period_end_date date
1415: ,c_pact_id pay_payroll_actions.payroll_action_id%type
1416: ) is
1417: select paa.assignment_action_id,

Line 3061: FROM per_all_assignments_f paaf,

3057: where assignment has payroll attached to it for few months but is not attached at the end of year*/
3058: CURSOR c_get_payroll_name(c_assignment_id number,c_end_date date, c_start_date date)
3059: IS
3060: SELECT paaf.payroll_id, pay.payroll_name
3061: FROM per_all_assignments_f paaf,
3062: pay_payrolls_f pay
3063: WHERE paaf.assignment_id = c_assignment_id
3064: and paaf.effective_end_date = (select max(effective_end_date)
3065: From per_assignments_f iipaf