DBA Data[Home] [Help]

APPS.PV_PRGM_APPROVAL_PVT dependencies on PV_PG_ENRL_CHANGE_RULES

Line 223: FROM pv_pg_enrl_change_rules

219: AND membership_status_code='ACTIVE'
220: AND program_id IN
221: (
222: SELECT distinct(change_to_program_id)
223: FROM pv_pg_enrl_change_rules
224: START WITH change_from_program_id=dependent_id
225: AND change_direction_code='UPGRADE'
226: AND ACTIVE_FLAG='Y'
227: AND nvl(EFFECTIVE_TO_DATE,sysdate+1)>=sysdate

Line 246: FROM pv_pg_enrl_change_rules

242: AND membership_status_code='FUTURE'
243: AND program_id IN
244: (
245: SELECT distinct(change_to_program_id)
246: FROM pv_pg_enrl_change_rules
247: START WITH change_from_program_id=dependent_id
248: AND change_direction_code='UPGRADE'
249: AND ACTIVE_FLAG='Y'
250: AND nvl(EFFECTIVE_TO_DATE,sysdate+1)>=sysdate