APPS.PV_PG_NOTIF_UTILITY_PVT dependencies on PV_PG_ENRL_REQUESTS

Line 125: -- from PV_PG_ENRL_REQUESTS table for a given enrl_requests_id

121: -- get_enrl_requests_details
122: --
123: -- PURPOSE
124: -- This procedure will return enrollment request details
125: -- from PV_PG_ENRL_REQUESTS table for a given enrl_requests_id
126: -- Called By
127: -- NOTES
128: -- End of Comments
129: ============================================================================*/

Line 152: FROM pv_pg_enrl_requests enrl_req,

148: prog.membership_valid_period ||' ' || lookup1.meaning,
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

Line 329: FROM pv_pg_enrl_requests enrl_req,

325: SELECT vendor.party_id VENDOR_ID,
326: vendor.party_name VENDOR_NAME,
327: partner.party_id PARTNER_ID,
328: partner.party_name PARTNER_NAME
329: FROM pv_pg_enrl_requests enrl_req,
330: pv_partner_profiles prtnr_profile,
331: hz_relationships rel_ship,
332: hz_parties partner,
333: hz_parties vendor

Line 406: pv_pg_enrl_requests enrl_req,

402: enrl_req.requestor_resource_id,
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

Line 841: -- from PV_PG_ENRL_REQUESTS table and PV_PG_MEMBERSHIPS_TABLE for a given enrl_requests_id

837: -- get_enrl_requests_details
838: --
839: -- PURPOSE
840: -- This procedure will return enrollment request and membership details
841: -- from PV_PG_ENRL_REQUESTS table and PV_PG_MEMBERSHIPS_TABLE for a given enrl_requests_id
842: -- Called By
843: -- NOTES
844: -- End of Comments
845: ============================================================================*/

Line 872: FROM pv_pg_enrl_requests enrl_req

868: , enrl_req.partner_id
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

Line 3870: FROM pv_pg_enrl_requests enrq

3866: whether we have to send any reminder notification or not in case of 'Signed
3867: Contract not received' notification */
3868: CURSOR c_Check_Cnrcvd_Rmdr_Flg (cv_enrl_request_id NUMBER) IS
3869: SELECT 'Y'
3870: FROM pv_pg_enrl_requests enrq
3871: WHERE enrq.enrl_request_id = cv_enrl_request_id
3872: AND enrq.contract_status_code = 'AWAITING_FAX_OR_MAIL';
3873:
3874: /* Declare local variables */

Line 4025: FROM pv_pg_enrl_requests enrq,

4021: notif_rule.repeat_freq_value*
4022: DECODE(notif_rule.repeat_freq_unit, 'PV_DAYS',1,
4023: 'PV_WEEK', 7,
4024: 'PV_MONTH', 30) "wait_time_in_days"
4025: FROM pv_pg_enrl_requests enrq,
4026: pv_ge_notif_rules_b notif_rule
4027: WHERE enrq.contract_status_code = 'AWAITING_FAX_OR_MAIL'
4028: AND enrq.request_status_code in ('AWAITING_APPROVAL', 'APPROVED')
4029: AND (enrq.request_submission_date -sysdate) < notif_rule.send_notif_after_value *