APPS.PV_ENRQ_BINS_PVT dependencies on PV_PG_ENRL_REQUESTS

Line 210: FROM pv_pg_enrl_requests

206:
207:
208: CURSOR enrl_csr(ptr_id NUMBER ,prgm_id NUMBER) IS
209: SELECT enrl_request_id,request_status_code,enrollment_type_code
210: FROM pv_pg_enrl_requests
211: WHERE enrl_request_id=
212: (
213: SELECT max(enrl_request_id)
214: FROM pv_pg_enrl_requests

Line 214: FROM pv_pg_enrl_requests

210: FROM pv_pg_enrl_requests
211: WHERE enrl_request_id=
212: (
213: SELECT max(enrl_request_id)
214: FROM pv_pg_enrl_requests
215: WHERE partner_id=ptr_id
216: AND program_id=prgm_id
217: );
218:

Line 571: FROM pv_pg_enrl_requests

567: AND active_flag = 'Y';
568:
569: CURSOR enrl_csr(ptr_id NUMBER ,prgm_id NUMBER) IS
570: SELECT enrl_request_id,request_status_code ,enrollment_type_code
571: FROM pv_pg_enrl_requests
572: WHERE enrl_request_id=
573: (
574: SELECT max(enrl_request_id)
575: FROM pv_pg_enrl_requests

Line 575: FROM pv_pg_enrl_requests

571: FROM pv_pg_enrl_requests
572: WHERE enrl_request_id=
573: (
574: SELECT max(enrl_request_id)
575: FROM pv_pg_enrl_requests
576: WHERE partner_id=ptr_id
577: AND program_id=prgm_id
578: AND enrollment_type_code='RENEW'
579: );

Line 593: FROM pv_pg_enrl_requests

589: AND change_from_program_id=prgm_id
590: AND
591: EXISTS
592: ( SELECT enrl_request_id
593: FROM pv_pg_enrl_requests
594: WHERE partner_id=ptr_id
595: AND request_status_code IN ('AWAITING_APPROVAL','APPROVED','INCOMPLETE')
596: AND program_id=rules.change_to_program_id
597: );

Line 882: FROM pv_pg_enrl_requests enrq

878: order by rules.change_to_program_id desc;
879:
880: CURSOR enrl_csr(ptr_id NUMBER ,prgm_id NUMBER) IS
881: SELECT enrq.enrl_request_id,enrq.request_status_code,enrq.enrollment_type_code, memb.membership_status_code
882: FROM pv_pg_enrl_requests enrq
883: , pv_pg_memberships memb
884: WHERE enrq.enrl_request_id=
885: (
886: SELECT max(enrl_request_id)

Line 887: FROM pv_pg_enrl_requests

883: , pv_pg_memberships memb
884: WHERE enrq.enrl_request_id=
885: (
886: SELECT max(enrl_request_id)
887: FROM pv_pg_enrl_requests
888: WHERE partner_id=ptr_id
889: AND program_id=prgm_id
890:
891: )

Line 1085: ,pv_pg_enrl_requests enrq

1081: ,pvppb.no_fee_flag no_fee_flag
1082: ,pvppb.vad_invite_allow_flag vad_invite_allow_flag
1083: FROM pv_partner_program_type_b pvpptb
1084: ,pv_partner_program_vl pvppb
1085: ,pv_pg_enrl_requests enrq
1086: WHERE pvppb.program_status_code = 'ACTIVE'
1087: AND pvppb.program_level_code ='MEMBERSHIP'
1088: AND pvppb.enabled_flag = 'Y'
1089: AND nvl(pvppb.allow_enrl_until_date, sysdate) > sysdate-1

Line 1108: FROM pv_pg_enrl_requests

1104: AND pvpptb.program_type_id = pvppt.program_type_id
1105: )
1106: AND enrq.enrl_request_id =
1107: ( SELECT max(enrl_request_id)
1108: FROM pv_pg_enrl_requests
1109: WHERE partner_id= p_ptr_id
1110: AND program_id=pvppb.PROGRAM_ID
1111: AND request_status_code='INCOMPLETE'
1112: )

Line 1562: FROM pv_pg_enrl_requests

1558: ;
1559:
1560: CURSOR enrl_csr( ptr_id IN NUMBER, prgm_id IN NUMBER ) IS
1561: SELECT request_status_code,enrollment_type_code
1562: FROM pv_pg_enrl_requests
1563: WHERE enrl_request_id=
1564: (
1565: SELECT max(enrl_request_id)
1566: FROM pv_pg_enrl_requests

Line 1566: FROM pv_pg_enrl_requests

1562: FROM pv_pg_enrl_requests
1563: WHERE enrl_request_id=
1564: (
1565: SELECT max(enrl_request_id)
1566: FROM pv_pg_enrl_requests
1567: WHERE partner_id=ptr_id
1568: AND program_id=prgm_id
1569:
1570: );