APPS.PV_PG_MEMBERSHIPS_PVT dependencies on PV_PARTNER_PROGRAM_VL

Line 1567: , pv_partner_program_vl prgm

1563: , enrq.partner_id
1564: , enrq.object_version_number
1565: , prgm.program_name
1566: FROM pv_pg_enrl_requests enrq
1567: , pv_partner_program_vl prgm
1568: WHERE enrq.enrl_request_id=enrl_id
1569: AND enrq.program_id=prgm.program_id;
1570:
1571: BEGIN

Line 1716: , pv_partner_program_vl prgm

1712: , memb.object_version_number
1713: , memb.enrl_request_id
1714: , prgm.program_name
1715: FROM pv_pg_memberships memb
1716: , pv_partner_program_vl prgm
1717: WHERE memb.membership_id=mmbr_id
1718: AND memb.program_id=prgm.program_id;
1719:
1720:

Line 3113: , pv_partner_program_vl prgm

3109: , original_end_date
3110: , enrl_request_id
3111: , program_name
3112: FROM pv_pg_memberships memb
3113: , pv_partner_program_vl prgm
3114: WHERE membership_id = p_memb_id
3115: AND memb.program_id=prgm.program_id;
3116:
3117: CURSOR to_program_csr ( p_progm_id IN NUMBER ) IS

Line 3119: FROM pv_partner_program_vl

3115: AND memb.program_id=prgm.program_id;
3116:
3117: CURSOR to_program_csr ( p_progm_id IN NUMBER ) IS
3118: SELECT program_name
3119: FROM pv_partner_program_vl
3120: where program_id=p_progm_id ;
3121:
3122:
3123: