APPS.PV_PG_NOTIF_UTILITY_PVT dependencies on PV_PARTNER_PROGRAM_VL

Line 153: pv_partner_program_vl prog,

149: lookup2.meaning,
150: enrl_req.Requestor_resource_id,
151: enrl_req.partner_id
152: FROM pv_pg_enrl_requests enrl_req,
153: pv_partner_program_vl prog,
154: fnd_lookups lookup1,
155: fnd_lookups lookup2
156: WHERE enrl_req.enrl_request_id = cv_enrl_request_id
157: AND enrl_req.program_id = prog.program_id

Line 407: pv_partner_program_vl program,

403: enrl_req.partner_id,
404: lookup.meaning
405: FROM pv_pg_memberships membership,
406: pv_pg_enrl_requests enrl_req,
407: pv_partner_program_vl program,
408: fnd_lookups lookup
409: WHERE membership.membership_id = cv_membership_id
410: AND enrl_req.enrl_request_id = membership.enrl_request_id
411: AND membership.program_id = program.program_id

Line 873: , pv_partner_program_vl prog

869: , memb.start_date
870: , memb.ORIGINAL_END_DATE
871: , memb.membership_id
872: FROM pv_pg_enrl_requests enrl_req
873: , pv_partner_program_vl prog
874: , fnd_lookups lookup1
875: , fnd_lookups lookup2
876: , pv_pg_memberships memb
877: WHERE enrl_req.enrl_request_id = cv_enrl_request_id

Line 4235: , pv_partner_program_vl prgm

4231: SELECT distinct party.party_name, prgm.program_name
4232: FROM hz_parties party
4233: , pv_partner_profiles prof
4234: , pv_pg_memberships memb
4235: , pv_partner_program_vl prgm
4236: WHERE prof.status = 'A'
4237: AND prof.partner_party_id = party.party_id
4238: AND memb.partner_id = prof.partner_id
4239: AND memb.membership_id = memb_id

Line 4928: FROM pv_partner_program_vl

4924: x_user_notify_rec_tbl user_notify_rec_tbl_type;
4925: l_val NUMBER;
4926: CURSOR c_prgm_csr ( prgm_id NUMBER ) IS
4927: SELECT program_name
4928: FROM pv_partner_program_vl
4929: WHERE program_id=prgm_id;
4930:
4931: CURSOR c_inv_csr ( inv_hdr_id NUMBER ) IS
4932: SELECT prgm.program_name

Line 4934: , pv_partner_program_vl prgm

4930:
4931: CURSOR c_inv_csr ( inv_hdr_id NUMBER ) IS
4932: SELECT prgm.program_name
4933: FROM PV_PG_INVITE_HEADERS_b inv
4934: , pv_partner_program_vl prgm
4935: WHERE inv.invite_header_id=inv_hdr_id
4936: AND inv.invite_for_program_id =prgm.program_id;
4937:
4938: BEGIN

Line 5745: FROM pv_partner_program_vl

5741: l_val NUMBER;
5742:
5743: CURSOR c_prgm_csr ( prgm_id NUMBER ) IS
5744: SELECT program_name
5745: FROM pv_partner_program_vl
5746: WHERE program_id=prgm_id;
5747:
5748: CURSOR c_inv_csr ( inv_hdr_id NUMBER ) IS
5749: SELECT prgm.program_name

Line 5751: , pv_partner_program_vl prgm

5747:
5748: CURSOR c_inv_csr ( inv_hdr_id NUMBER ) IS
5749: SELECT prgm.program_name
5750: FROM PV_PG_INVITE_HEADERS_b inv
5751: , pv_partner_program_vl prgm
5752: WHERE inv.invite_header_id=inv_hdr_id
5753: AND inv.invite_for_program_id =prgm.program_id;
5754:
5755: CURSOR c_currency_csr ( currencyCode VARCHAR2 ) IS