eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PV_ENRQ_BINS_PVT dependencies on PV_PG_MEMBERSHIPS

Line 80: select membership_id from pv_pg_memberships

76: CURSOR isenroll_csr(p_prgm_id NUMBER,p_global_ptr_id NUMBER) IS
77: Select 'X' from dual
78: WHERE EXISTS
79: (
80: select membership_id from pv_pg_memberships
81: where membership_status_code in ('ACTIVE','FUTURE')
82: AND partner_id=p_global_ptr_id
83: AND program_id IN
84: (

Line 221: FROM pv_pg_memberships

217: );
218:
219: CURSOR memb_csr(enrl_id NUMBER) IS
220: SELECT membership_id,membership_status_code
221: FROM pv_pg_memberships
222: WHERE enrl_request_id=enrl_id;
223:
224: CURSOR prgm_wo_prereq_csr(ptnr_id IN NUMBER) IS
225: SELECT pvppb.program_id program_id

Line 514: ,pv_pg_memberships memb

510: ,memb.original_end_date original_end_date
511: -- ,inv.invite_header_id invite_header_id
512: FROM pv_partner_program_type_b pvpptb
513: ,pv_partner_program_vl pvppb
514: ,pv_pg_memberships memb
515: -- ,pv_pg_invite_headers_b inv
516: WHERE pvppb.program_status_code = 'ACTIVE'
517: AND pvppb.program_level_code ='MEMBERSHIP'
518: AND pvppb.enabled_flag = 'Y'

Line 544: FROM PV_PG_MEMBERSHIPS

540: )
541: AND pvppb.program_id =memb.program_id
542: AND memb.membership_id =
543: ( SELECT max(membership_id)
544: FROM PV_PG_MEMBERSHIPS
545: WHERE program_id=memb.program_id
546: AND partner_id=ptr_id
547: AND MEMBERSHIP_STATUS_CODE IN ('ACTIVE','EXPIRED')
548:

Line 601: FROM pv_pg_memberships

597: );
598:
599: CURSOR memb_csr(enrl_id NUMBER) IS
600: SELECT membership_status_code
601: FROM pv_pg_memberships
602: WHERE enrl_request_id=enrl_id;
603:
604: l_enrq_param_tbl PV_ENRL_REQ_PARAM_TBL := PV_ENRL_REQ_PARAM_TBL ();
605: l_api_name CONSTANT VARCHAR2(30) := 'renewable_programs';

Line 806: ,pv_pg_memberships memb

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:
810: WHERE pvppb.program_status_code = 'ACTIVE'

Line 822: FROM pv_pg_memberships memb10

818: AND memb.partner_id=p_ptr_id
819: --AND memb.membership_status_code in ('ACTIVE' , 'UPGRADED')
820: AND memb.program_id= (
821: SELECT memb10.program_id
822: FROM pv_pg_memberships memb10
823: WHERE memb10.membership_id =
824: ( SELECT max(membership_id)
825: FROM pv_pg_memberships memb9
826: WHERE memb9.program_id=memb.program_id

Line 825: FROM pv_pg_memberships memb9

821: SELECT memb10.program_id
822: FROM pv_pg_memberships memb10
823: WHERE memb10.membership_id =
824: ( SELECT max(membership_id)
825: FROM pv_pg_memberships memb9
826: WHERE memb9.program_id=memb.program_id
827: AND memb9.partner_id=memb.partner_id
828: )
829: AND memb10.membership_status_code in ('ACTIVE' , 'UPGRADED')

Line 839: FROM pv_pg_memberships memb2

835: AND rules.active_flag = 'Y'
836: AND rules.change_to_program_id=pvppb.program_id
837: AND rules.change_to_program_id not in (
838: /*SELECT memb2.program_id
839: FROM pv_pg_memberships memb2
840: WHERE memb2.program_id=rules.change_to_program_id
841: AND memb2.partner_id=memb.partner_id
842: AND memb2.membership_status_code in ('ACTIVE','UPGRADED','EXPIRED')
843: */

Line 845: FROM pv_pg_memberships memb2

841: AND memb2.partner_id=memb.partner_id
842: AND memb2.membership_status_code in ('ACTIVE','UPGRADED','EXPIRED')
843: */
844: SELECT memb2.program_id
845: FROM pv_pg_memberships memb2
846: WHERE memb2.membership_id =
847: (
848: SELECT max(membership_id)
849: FROM pv_pg_memberships memb3

Line 849: FROM pv_pg_memberships memb3

845: FROM pv_pg_memberships memb2
846: WHERE memb2.membership_id =
847: (
848: SELECT max(membership_id)
849: FROM pv_pg_memberships memb3
850: WHERE memb3.program_id=rules.change_to_program_id
851: AND memb3.partner_id=memb.partner_id
852:
853: )

Line 883: , pv_pg_memberships memb

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)
887: FROM pv_pg_enrl_requests

Line 1482: , pv_pg_memberships memb

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'
1486: AND pvppb.program_level_code ='MEMBERSHIP'

Line 1498: FROM pv_pg_memberships memb10

1494: AND memb.partner_id=p_ptr_id
1495: --AND memb.membership_status_code in ('ACTIVE' , 'UPGRADED')
1496: AND memb.program_id= (
1497: SELECT memb10.program_id
1498: FROM pv_pg_memberships memb10
1499: WHERE memb10.membership_id =
1500: ( SELECT max(membership_id)
1501: FROM pv_pg_memberships memb9
1502: WHERE memb9.program_id=memb.program_id

Line 1501: FROM pv_pg_memberships memb9

1497: SELECT memb10.program_id
1498: FROM pv_pg_memberships memb10
1499: WHERE memb10.membership_id =
1500: ( SELECT max(membership_id)
1501: FROM pv_pg_memberships memb9
1502: WHERE memb9.program_id=memb.program_id
1503: AND memb9.partner_id=memb.partner_id
1504: )
1505: AND memb10.membership_status_code in ('ACTIVE' , 'UPGRADED')

Line 1517: FROM pv_pg_memberships memb2

1513: AND rules.change_to_program_id=p_to_id
1514: AND rules.change_to_program_id not in
1515: (
1516: /* SELECT memb2.program_id
1517: FROM pv_pg_memberships memb2
1518: WHERE memb2.program_id=p_to_id
1519: AND memb2.partner_id=p_ptr_id
1520: AND memb2.membership_status_code in ('ACTIVE', 'UPGRADED')
1521: */

Line 1523: FROM pv_pg_memberships memb2

1519: AND memb2.partner_id=p_ptr_id
1520: AND memb2.membership_status_code in ('ACTIVE', 'UPGRADED')
1521: */
1522: SELECT memb2.program_id
1523: FROM pv_pg_memberships memb2
1524: WHERE memb2.membership_id =
1525: (
1526: SELECT max(membership_id)
1527: FROM pv_pg_memberships memb3

Line 1527: FROM pv_pg_memberships memb3

1523: FROM pv_pg_memberships memb2
1524: WHERE memb2.membership_id =
1525: (
1526: SELECT max(membership_id)
1527: FROM pv_pg_memberships memb3
1528: WHERE memb3.program_id=rules.change_to_program_id
1529: AND memb3.partner_id=memb.partner_id
1530: )
1531: AND memb2.membership_status_code in ('ACTIVE','UPGRADED','EXPIRED')