DBA Data[Home] [Help]

APPS.PAY_IE_P35 dependencies on PAY_RUN_TYPES_F

Line 2132: pay_run_types_f prt

2128: CURSOR csr_child_actions(p_asg_id number) IS
2129: SELECT paa.assignment_action_id child_assignment_action_id
2130: --,prt.run_method run_type
2131: FROM pay_assignment_actions paa,
2132: pay_run_types_f prt
2133: WHERE paa.run_type_id = prt.run_type_id
2134: AND prt.run_method IN ('N','P')
2135: AND p_effective_date BETWEEN prt.effective_start_date AND prt.effective_end_date
2136: AND paa.assignment_action_id = (SELECT /*+ USE_NL(paa, ppa) */