APPS.PV_ENRQ_BINS_PVT dependencies on PV_PG_ENRL_CHANGE_RULES

Line 85: select CHANGE_to_program_id from pv_pg_enrl_change_rules

81: where membership_status_code in ('ACTIVE','FUTURE')
82: AND partner_id=p_global_ptr_id
83: AND program_id IN
84: (
85: select CHANGE_to_program_id from pv_pg_enrl_change_rules
86: where change_direction_code='UPGRADE'
87: AND ACTIVE_FLAG='Y'
88: START with change_from_program_id=p_prgm_id
89: CONNECT by CHANGE_FROM_PROGRAM_id=PRIOR CHANGE_to_program_id

Line 193: FROM pv_pg_enrl_change_rules rules

189: )
190: AND pvppb.program_id NOT IN
191: (
192: SELECT rules.change_to_program_id
193: FROM pv_pg_enrl_change_rules rules
194: WHERE change_direction_code = 'UPGRADE'
195: AND effective_from_date <= sysdate
196: AND nvl(effective_to_date, sysdate) >= sysdate
197: AND active_flag = 'Y'

Line 256: FROM pv_pg_enrl_change_rules rules

252: )
253: AND pvppb.program_id NOT IN
254: (
255: SELECT rules.change_to_program_id
256: FROM pv_pg_enrl_change_rules rules
257: WHERE change_direction_code = 'UPGRADE'
258: AND effective_from_date <= sysdate
259: AND nvl(effective_to_date, sysdate) >= sysdate
260: AND active_flag = 'Y'

Line 584: FROM pv_pg_enrl_change_rules rules

580:
581:
582: CURSOR upgrade_rule_csr(prgm_id NUMBER,ptr_id NUMBER) IS
583: SELECT 'X'
584: FROM pv_pg_enrl_change_rules rules
585: WHERE change_direction_code = 'UPGRADE'
586: AND effective_from_date <= sysdate
587: AND nvl(effective_to_date, sysdate) >= sysdate
588: AND active_flag = 'Y'

Line 805: FROM pv_pg_enrl_change_rules rules

801: ,pvppb.global_mmbr_reqd_flag global_mmbr_reqd_flag
802: ,pvppb.prereq_process_rule_id prereq_process_rule_id
803: ,pvppb.no_fee_flag no_fee_flag
804: ,pvppb.vad_invite_allow_flag vad_invite_allow_flag
805: FROM pv_pg_enrl_change_rules rules
806: ,pv_pg_memberships memb
807: ,pv_partner_program_vl pvppb
808: ,pv_partner_program_type_b pvpptb
809:

Line 1447: FROM pv_pg_enrl_change_rules rules

1443: AND pvpptb.enabled_flag = 'Y'
1444: AND program_id NOT IN
1445: (
1446: SELECT rules.change_to_program_id
1447: FROM pv_pg_enrl_change_rules rules
1448: WHERE change_direction_code = 'UPGRADE'
1449: AND effective_from_date <= sysdate
1450: AND nvl(effective_to_date, sysdate) >= sysdate
1451: AND active_flag = 'Y'

Line 1481: FROM pv_pg_enrl_change_rules rules

1477:
1478: CURSOR c_upgrade_csr( p_ptr_id IN NUMBER, p_from_id IN NUMBER, p_to_id IN NUMBER) IS
1479: SELECT 'Y'
1480: , global_mmbr_reqd_flag
1481: FROM pv_pg_enrl_change_rules rules
1482: , pv_pg_memberships memb
1483: , pv_partner_program_vl pvppb
1484: , pv_partner_program_type_b pvpptb
1485: WHERE pvppb.program_status_code = 'ACTIVE'