APPS.PV_ENRL_PREREQ_BINS_PUB dependencies on PV_PG_ENRL_CHANGE_RULES

Line 119: FROM pv_pg_enrl_change_rules rule

115: WHERE status = 'A';
116:
117: CURSOR c_get_prereq (c_program_id NUMBER) IS
118: SELECT change_from_program_id
119: FROM pv_pg_enrl_change_rules rule
120: WHERE rule.change_to_program_id = c_program_id
121: AND rule.change_direction_code = 'PREREQUISITE'
122: AND rule.EFFECTIVE_FROM_DATE <= SYSDATE
123: AND NVL(rule.EFFECTIVE_TO_DATE, SYSDATE+1) >= SYSDATE