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 45: hr_soft_coding_keyflex sck,

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

Line 256: FROM hr_soft_coding_keyflex flex,

252: --
253: CURSOR c_tax_ref(p_assignment_id IN NUMBER,
254: p_eff_date IN DATE) IS
255: SELECT flex.segment1 tax_ref
256: FROM hr_soft_coding_keyflex flex,
257: per_assignments_f asg,
258: Pay_payrolls_f ppf
259: WHERE asg.assignment_id = p_assignment_id
260: AND p_eff_date BETWEEN asg.effective_start_date AND asg.effective_end_date

Line 265: l_previous_tax_ref hr_soft_coding_keyflex.segment1%TYPE;

261: AND asg.payroll_id = ppf.payroll_id
262: AND p_eff_date BETWEEN ppf.effective_start_Date and ppf.effective_end_date
263: AND ppf.soft_coding_keyflex_id = flex.soft_coding_keyflex_id;
264: --
265: l_previous_tax_ref hr_soft_coding_keyflex.segment1%TYPE;
266: l_next_tax_ref hr_soft_coding_keyflex.segment1%TYPE;
267: --
268: --
269: -- Check if the private use flag is changed from Y to NULL or N.

Line 266: l_next_tax_ref hr_soft_coding_keyflex.segment1%TYPE;

262: AND p_eff_date BETWEEN ppf.effective_start_Date and ppf.effective_end_date
263: AND ppf.soft_coding_keyflex_id = flex.soft_coding_keyflex_id;
264: --
265: l_previous_tax_ref hr_soft_coding_keyflex.segment1%TYPE;
266: l_next_tax_ref hr_soft_coding_keyflex.segment1%TYPE;
267: --
268: --
269: -- Check if the private use flag is changed from Y to NULL or N.
270: -- in this case it is considered as car withdrawal.

Line 848: FROM hr_soft_coding_keyflex flex,

844: */
845: asg.assignment_id,
846: min(asg.effective_start_date) asg_min_start_date,
847: max(asg.effective_end_date) asg_max_end_date
848: FROM hr_soft_coding_keyflex flex,
849: per_all_assignments_f asg,
850: pay_payrolls_f ppf,
851: pqp_vehicle_allocations_f va,
852: pqp_vehicle_repository_f vr

Line 1313: FROM hr_soft_coding_keyflex flex,

1309: */
1310: asg.assignment_id,
1311: min(asg.effective_start_date) asg_min_start_date,
1312: max(asg.effective_end_date) asg_max_end_date
1313: FROM hr_soft_coding_keyflex flex,
1314: per_all_assignments_f asg,
1315: pay_payrolls_f ppf,
1316: pqp_vehicle_allocations_f va,
1317: pqp_vehicle_repository_f vr

Line 1847: FROM hr_soft_coding_keyflex flex,

1843: */
1844: asg.assignment_id,
1845: min(asg.effective_start_date) asg_min_start_date,
1846: max(asg.effective_end_date) asg_max_end_date
1847: FROM hr_soft_coding_keyflex flex,
1848: per_all_assignments_f asg,
1849: pay_payrolls_f ppf,
1850: pqp_vehicle_allocations_f va,
1851: pqp_vehicle_repository_f vr

Line 2387: FROM hr_soft_coding_keyflex flex,

2383: */
2384: asg.assignment_id,
2385: min(asg.effective_start_date) asg_min_start_date,
2386: max(asg.effective_end_date) asg_max_end_date
2387: FROM hr_soft_coding_keyflex flex,
2388: per_all_assignments_f asg,
2389: pay_payrolls_f ppf,
2390: pqp_vehicle_allocations_f va,
2391: pqp_vehicle_repository_f vr

Line 3359: FROM hr_soft_coding_keyflex flex,

3355: CURSOR c_asg IS
3356: SELECT asg.assignment_id,
3357: min(asg.effective_start_date) asg_min_start_date,
3358: max(asg.effective_end_date) asg_max_end_date
3359: FROM hr_soft_coding_keyflex flex,
3360: per_all_assignments_f asg,
3361: Pay_payrolls_f ppf,
3362: pay_assignment_actions act
3363: WHERE act.assignment_action_id = p_assactid

Line 3795: FROM hr_soft_coding_keyflex flex,

3791: CURSOR c_asg IS
3792: SELECT asg.assignment_id,
3793: min(asg.effective_start_date) asg_min_start_date,
3794: max(asg.effective_end_date) asg_max_end_date
3795: FROM hr_soft_coding_keyflex flex,
3796: per_all_assignments_f asg,
3797: Pay_payrolls_f ppf,
3798: pay_assignment_actions act
3799: WHERE act.assignment_action_id = p_assactid

Line 4294: FROM hr_soft_coding_keyflex flex,

4290: CURSOR c_asg IS
4291: SELECT asg.assignment_id,
4292: min(asg.effective_start_date) asg_min_start_date,
4293: max(asg.effective_end_date) asg_max_end_date
4294: FROM hr_soft_coding_keyflex flex,
4295: per_all_assignments_f asg,
4296: Pay_payrolls_f ppf,
4297: pay_assignment_actions act
4298: WHERE act.assignment_action_id = p_assactid

Line 4800: FROM hr_soft_coding_keyflex flex,

4796: CURSOR c_asg IS
4797: SELECT asg.assignment_id,
4798: min(asg.effective_start_date) asg_min_start_date,
4799: max(asg.effective_end_date) asg_max_end_date
4800: FROM hr_soft_coding_keyflex flex,
4801: per_all_assignments_f asg,
4802: Pay_payrolls_f ppf,
4803: pay_assignment_actions act
4804: WHERE act.assignment_action_id = p_assactid