APPS.PAY_IE_EHECS_REPORT_PKG dependencies on PAY_RUN_TYPES_F

Line 2446: pay_run_types_f prt

2442: --
2443: and exists (SELECT paa.assignment_action_id child_assignment_action_id,
2444: prt.run_method run_type
2445: FROM pay_assignment_actions paa,
2446: pay_run_types_f prt
2447: WHERE paa.run_type_id = prt.run_type_id
2448: AND prt.run_method IN ('N','P')
2449: AND g_qtr_start_date BETWEEN prt.effective_start_date AND prt.effective_end_date
2450: AND paa.assignment_action_id = (SELECT /*+ USE_NL(paa, ppa) */

Line 2555: pay_run_types_f prt

2551: --
2552: and exists (SELECT paa.assignment_action_id child_assignment_action_id,
2553: prt.run_method run_type
2554: FROM pay_assignment_actions paa,
2555: pay_run_types_f prt
2556: WHERE paa.run_type_id = prt.run_type_id
2557: AND prt.run_method IN ('N','P')
2558: AND g_qtr_start_date BETWEEN prt.effective_start_date AND prt.effective_end_date
2559: AND paa.assignment_action_id = (SELECT /*+ USE_NL(paa, ppa) */

Line 2672: pay_run_types_f prt

2668: and g_qtr_start_date between paaf.effective_start_date and paaf.effective_end_date
2669: and exists (SELECT paa.assignment_action_id child_assignment_action_id,
2670: prt.run_method run_type
2671: FROM pay_assignment_actions paa,
2672: pay_run_types_f prt
2673: WHERE paa.run_type_id = prt.run_type_id
2674: AND prt.run_method IN ('N','P')
2675: AND g_qtr_start_date BETWEEN prt.effective_start_date AND prt.effective_end_date
2676: AND paa.assignment_action_id = (SELECT /*+ USE_NL(paa, ppa)

Line 2805: pay_run_types_f prt

2801: --
2802: and exists (SELECT paa.assignment_action_id child_assignment_action_id,
2803: prt.run_method run_type
2804: FROM pay_assignment_actions paa,
2805: pay_run_types_f prt
2806: WHERE paa.run_type_id = prt.run_type_id
2807: AND prt.run_method IN ('N','P')
2808: AND g_qtr_start_date BETWEEN prt.effective_start_date AND prt.effective_end_date
2809: AND paa.assignment_action_id = (SELECT /*+ USE_NL(paa, ppa) */