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 HR_SOFT_CODING_KEYFLEX

Line 43: hr_soft_coding_keyflex sck,

39: --
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

Line 210: FROM hr_soft_coding_keyflex flex,

206: --
207: CURSOR c_tax_ref(p_assignment_id IN NUMBER,
208: p_eff_date IN DATE) IS
209: SELECT flex.segment1 tax_ref
210: FROM hr_soft_coding_keyflex flex,
211: per_assignments_f asg,
212: Pay_payrolls_f ppf
213: WHERE asg.assignment_id = p_assignment_id
214: AND p_eff_date BETWEEN asg.effective_start_date AND asg.effective_end_date

Line 219: l_previous_tax_ref hr_soft_coding_keyflex.segment1%TYPE;

215: AND asg.payroll_id = ppf.payroll_id
216: AND p_eff_date BETWEEN ppf.effective_start_Date and ppf.effective_end_date
217: AND ppf.soft_coding_keyflex_id = flex.soft_coding_keyflex_id;
218: --
219: l_previous_tax_ref hr_soft_coding_keyflex.segment1%TYPE;
220: l_next_tax_ref hr_soft_coding_keyflex.segment1%TYPE;
221: --
222: -----------------------------------------------------
223: -- FUNCTION CHK_ACTION_ARCHIVED --

Line 220: l_next_tax_ref hr_soft_coding_keyflex.segment1%TYPE;

216: AND p_eff_date BETWEEN ppf.effective_start_Date and ppf.effective_end_date
217: AND ppf.soft_coding_keyflex_id = flex.soft_coding_keyflex_id;
218: --
219: l_previous_tax_ref hr_soft_coding_keyflex.segment1%TYPE;
220: l_next_tax_ref hr_soft_coding_keyflex.segment1%TYPE;
221: --
222: -----------------------------------------------------
223: -- FUNCTION CHK_ACTION_ARCHIVED --
224: -----------------------------------------------------

Line 556: FROM hr_soft_coding_keyflex flex,

552: */
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

Line 1021: FROM hr_soft_coding_keyflex flex,

1017: */
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

Line 1860: FROM hr_soft_coding_keyflex flex,

1856: CURSOR c_asg IS
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

Line 2297: FROM hr_soft_coding_keyflex flex,

2293: CURSOR c_asg IS
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