APPS.PV_USER_MGMT_PVT dependencies on PV_PG_ENRL_CHANGE_RULES

Line 2267: FROM pv_pg_enrl_change_rules rule

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