APPS.PAY_IE_LEGISLATIVE_ARCHIVE dependencies on PAY_RUN_TYPES_F

Line 1744: pay_run_types_f prt

1740: IS
1741: SELECT paa1.assignment_action_id child_assignment_action_id
1742: ,prt.run_method run_type
1743: FROM pay_assignment_actions paa1,
1744: pay_run_types_f prt
1745: WHERE paa1.run_type_id = prt.run_type_id
1746: AND prt.run_method IN ('N','P')
1747: AND p_effective_date BETWEEN prt.effective_start_date AND prt.effective_end_date
1748: AND paa1.assignment_action_id IN

Line 2738: pay_run_types_f prt

2734: p_effective_date DATE ) IS
2735: SELECT paa.assignment_action_id child_assignment_action_id,
2736: 'S' run_type
2737: FROM pay_assignment_actions paa,
2738: pay_run_types_f prt
2739: WHERE paa.source_action_id = p_master_assignment_action
2740: AND paa.payroll_action_id = p_payroll_action_id
2741: AND paa.assignment_id = p_assignment_id
2742: AND paa.run_type_id = prt.run_type_id

Line 2754: pay_run_types_f prt1

2750: WHERE paa.payroll_action_id = p_payroll_action_id
2751: AND paa.assignment_id = p_assignment_id
2752: AND paa.action_sequence = (SELECT MAX(paa1.action_sequence)
2753: FROM pay_assignment_actions paa1,
2754: pay_run_types_f prt1
2755: WHERE prt1.run_type_id = paa1.run_type_id
2756: AND prt1.run_method IN ('N','P')
2757: AND paa1.payroll_action_id = p_payroll_action_id
2758: AND paa1.assignment_id = p_assignment_id

Line 2769: pay_run_types_f prt

2765: p_effective_date DATE ) IS
2766: /*SELECT paa.assignment_action_id child_assignment_action_id,
2767: 'S' run_type
2768: FROM pay_assignment_actions paa,
2769: pay_run_types_f prt
2770: WHERE paa.run_type_id = prt.run_type_id
2771: AND prt.run_method = 'S'
2772: AND p_effective_date BETWEEN prt.effective_start_date AND prt.effective_end_date
2773: AND paa.assignment_action_id = (SELECT /*+ USE_NL(paa, ppa)

Line 2789: pay_run_types_f prt

2785: -- Bug Fix 4260031
2786: SELECT paa.assignment_action_id child_assignment_action_id,
2787: prt.run_method run_type
2788: FROM pay_assignment_actions paa,
2789: pay_run_types_f prt
2790: WHERE paa.run_type_id = prt.run_type_id
2791: AND prt.run_method IN ('N','P')
2792: AND p_effective_date BETWEEN prt.effective_start_date AND prt.effective_end_date
2793: AND paa.assignment_action_id = (SELECT /*+ USE_NL(paa, ppa) */

Line 2814: pay_run_types_f prt

2810: p_effective_date DATE) IS
2811: SELECT paa.assignment_action_id np_assignment_action_id,
2812: prt.run_method
2813: FROM pay_assignment_actions paa,
2814: pay_run_types_f prt
2815: WHERE paa.source_action_id = p_assignment_action_id
2816: AND paa.payroll_action_id = p_payroll_action_id
2817: AND paa.assignment_id = p_assignment_id
2818: AND paa.run_type_id = prt.run_type_id

Line 2829: pay_run_types_f prt

2825: p_effective_date DATE) IS
2826: SELECT paa.assignment_action_id np_assignment_action_id,
2827: prt.run_method
2828: FROM pay_assignment_actions paa,
2829: pay_run_types_f prt
2830: WHERE paa.run_type_id = prt.run_type_id
2831: AND prt.run_method IN ('N','P')
2832: AND p_effective_date BETWEEN prt.effective_start_date AND prt.effective_end_date
2833: AND paa.assignment_action_id = (SELECT /*+ USE_NL(paa, ppa)