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

Line 44: per_all_assignments_f paaf,

40: CURSOR c_first_asg (p_assignment_id IN NUMBER, p_eff_date IN DATE) IS
41: SELECT min(paaf.assignment_id) assignment_id
42: FROM pay_all_payrolls_f papf,
43: hr_soft_coding_keyflex sck,
44: per_all_assignments_f paaf,
45: per_all_assignments_f paaf2,
46: Pqp_vehicle_repository_f vr,
47: Pqp_vehicle_allocations_f va
48: WHERE paaf2.assignment_id = p_assignment_id

Line 45: per_all_assignments_f paaf2,

41: SELECT min(paaf.assignment_id) assignment_id
42: FROM pay_all_payrolls_f papf,
43: hr_soft_coding_keyflex sck,
44: per_all_assignments_f paaf,
45: per_all_assignments_f paaf2,
46: Pqp_vehicle_repository_f vr,
47: Pqp_vehicle_allocations_f va
48: WHERE paaf2.assignment_id = p_assignment_id
49: AND paaf2.person_id = paaf.person_id

Line 557: per_all_assignments_f asg,

553: asg.assignment_id,
554: min(asg.effective_start_date) asg_min_start_date,
555: max(asg.effective_end_date) asg_max_end_date
556: FROM hr_soft_coding_keyflex flex,
557: per_all_assignments_f asg,
558: pay_payrolls_f ppf,
559: pqp_vehicle_allocations_f va,
560: pqp_vehicle_repository_f vr
561: WHERE asg.person_id BETWEEN stperson AND endperson

Line 1022: per_all_assignments_f asg,

1018: asg.assignment_id,
1019: min(asg.effective_start_date) asg_min_start_date,
1020: max(asg.effective_end_date) asg_max_end_date
1021: FROM hr_soft_coding_keyflex flex,
1022: per_all_assignments_f asg,
1023: pay_payrolls_f ppf,
1024: pqp_vehicle_allocations_f va,
1025: pqp_vehicle_repository_f vr
1026: WHERE asg.person_id BETWEEN stperson AND endperson

Line 1861: per_all_assignments_f asg,

1857: SELECT asg.assignment_id,
1858: min(asg.effective_start_date) asg_min_start_date,
1859: max(asg.effective_end_date) asg_max_end_date
1860: FROM hr_soft_coding_keyflex flex,
1861: per_all_assignments_f asg,
1862: Pay_payrolls_f ppf,
1863: pay_assignment_actions act
1864: WHERE act.assignment_action_id = p_assactid
1865: AND act.assignment_id = asg.assignment_id

Line 2298: per_all_assignments_f asg,

2294: SELECT asg.assignment_id,
2295: min(asg.effective_start_date) asg_min_start_date,
2296: max(asg.effective_end_date) asg_max_end_date
2297: FROM hr_soft_coding_keyflex flex,
2298: per_all_assignments_f asg,
2299: Pay_payrolls_f ppf,
2300: pay_assignment_actions act
2301: WHERE act.assignment_action_id = p_assactid
2302: AND act.assignment_id = asg.assignment_id