APPS.PV_USER_MGMT_PVT dependencies on PV_PG_ENRL_CHANGE_RULES

Line 2270: FROM pv_pg_enrl_change_rules rule

2266: AND prg.enabled_flag = 'Y';
2267:
2268: CURSOR c_get_prereq (c_program_id NUMBER) IS
2269: SELECT change_from_program_id
2270: FROM pv_pg_enrl_change_rules rule
2271: WHERE rule.change_to_program_id = c_program_id
2272: AND rule.change_direction_code = 'PREREQUISITE'
2273: AND rule.EFFECTIVE_FROM_DATE <= SYSDATE
2274: AND NVL(rule.EFFECTIVE_TO_DATE, SYSDATE+1) >= SYSDATE