APPS.PAY_IE_EHECS_REPORT_PKG dependencies on PAY_RUN_TYPES_F

Line 2729: pay_run_types_f prt

2725: --
2726: and exists (SELECT paa.assignment_action_id child_assignment_action_id,
2727: prt.run_method run_type
2728: FROM pay_assignment_actions paa,
2729: pay_run_types_f prt
2730: WHERE paa.run_type_id = prt.run_type_id
2731: AND prt.run_method IN ('N','P')
2732: AND g_qtr_start_date BETWEEN prt.effective_start_date AND prt.effective_end_date
2733: AND paa.assignment_action_id = (SELECT /*+ USE_NL(paa, ppa) */

Line 2840: pay_run_types_f prt

2836: --
2837: and exists (SELECT paa.assignment_action_id child_assignment_action_id,
2838: prt.run_method run_type
2839: FROM pay_assignment_actions paa,
2840: pay_run_types_f prt
2841: WHERE paa.run_type_id = prt.run_type_id
2842: AND prt.run_method IN ('N','P')
2843: AND g_qtr_start_date BETWEEN prt.effective_start_date AND prt.effective_end_date
2844: AND paa.assignment_action_id = (SELECT /*+ USE_NL(paa, ppa) */

Line 2959: pay_run_types_f prt

2955: and g_qtr_start_date between paaf.effective_start_date and paaf.effective_end_date
2956: and exists (SELECT paa.assignment_action_id child_assignment_action_id,
2957: prt.run_method run_type
2958: FROM pay_assignment_actions paa,
2959: pay_run_types_f prt
2960: WHERE paa.run_type_id = prt.run_type_id
2961: AND prt.run_method IN ('N','P')
2962: AND g_qtr_start_date BETWEEN prt.effective_start_date AND prt.effective_end_date
2963: AND paa.assignment_action_id = (SELECT /*+ USE_NL(paa, ppa)

Line 3092: pay_run_types_f prt

3088: --
3089: and exists (SELECT paa.assignment_action_id child_assignment_action_id,
3090: prt.run_method run_type
3091: FROM pay_assignment_actions paa,
3092: pay_run_types_f prt
3093: WHERE paa.run_type_id = prt.run_type_id
3094: AND prt.run_method IN ('N','P')
3095: AND g_qtr_start_date BETWEEN prt.effective_start_date AND prt.effective_end_date
3096: AND paa.assignment_action_id = (SELECT /*+ USE_NL(paa, ppa) */