APPS.PV_BENFT_STATUS_CHANGE dependencies on PV_GE_BENEFITS_B

Line 35: select benefit_type_code from pv_ge_benefits_b

31: l_api_name CONSTANT VARCHAR2(30) := 'STATUS_CHANGE_NOTIFICATION';
32: l_api_version_number CONSTANT NUMBER := 1.0;
33:
34: CURSOR lc_get_benefit_type (pc_benefit_id number) is
35: select benefit_type_code from pv_ge_benefits_b
36: where benefit_id = pc_benefit_id;
37:
38: CURSOR lc_get_message (pc_benefit_id number, pc_status varchar2, pc_userrole varchar2) is
39: select user_role, wf_message_type, wf_message_name

Line 457: from pv_referrals_b ref, pv_ge_benefits_b ben

453:
454: cursor lc_get_entity_detail (pc_entity_id number) is
455: select ref.referral_code, ben.benefit_type_code, ref.entity_type, ref.entity_id_linked_to,
456: ref.decline_reason_code, ref.order_id
457: from pv_referrals_b ref, pv_ge_benefits_b ben
458: where ref.referral_id = pc_entity_id and ref.benefit_id = ben.benefit_id;
459:
460: cursor lc_oppty_linked_flag (pc_lead_id number) is
461: select lead_number, prm_referral_code from as_leads_all where lead_id = pc_lead_id;