APPS.PV_REFERRAL_GENERAL_PUB dependencies on PV_REFERRALS_VL

Line 118: FROM pv_referrals_vl REF,

114: l_parameter_t wf_parameter_t := wf_parameter_t(null, null);
115:
116: CURSOR c_closed_lost_oppty IS
117: SELECT REF.referral_id, REF.referral_name, REF.benefit_id, REF.partner_id
118: FROM pv_referrals_vl REF,
119: as_leads_all OPPTY,
120: as_statuses_b STATUS
121: WHERE REF.referral_status = 'APPROVED' AND
122: REF.entity_type IN ('LEAD') AND

Line 131: FROM pv_referrals_vl REF,

127:
128:
129: CURSOR c_closed_oppty_won IS
130: SELECT REF.referral_id, REF.referral_name, REF.benefit_id, REF.partner_id
131: FROM pv_referrals_vl REF,
132: as_leads_all OPPTY,
133: as_statuses_b STATUS
134: WHERE REF.referral_status = 'APPROVED' AND
135: REF.entity_type IN ('LEAD') AND

Line 143: FROM pv_referrals_vl REF,

139: STATUS.win_loss_indicator = 'W';
140:
141: CURSOR c_closed_dead_lead IS
142: SELECT REF.referral_id, REF.referral_name, REF.benefit_id, REF.partner_id
143: FROM pv_referrals_vl REF,
144: as_sales_leads LEAD
145: WHERE REF.referral_status = 'APPROVED' AND
146: REF.entity_type = 'SALES_LEAD' AND
147: REF.entity_id_linked_to = LEAD.sales_lead_id AND

Line 152: FROM pv_referrals_vl REF,

148: LEAD.status_code = 'DEAD_LEAD';
149:
150: CURSOR c_expired IS
151: SELECT REF.referral_id, REF.referral_name, REF.benefit_id, REF.partner_id
152: FROM pv_referrals_vl REF,
153: pv_benft_thresholds THR,
154: jtf_terr_all TR,
155: jtf_terr_qual_all TQ,
156: jtf_terr_values_all TV

Line 2022: FROM pv_ge_benefits_vl a, pv_referrals_vl b

2018: WHERE sales_lead_id = pc_entity_id;
2019:
2020: CURSOR c_benefit_type IS
2021: SELECT a.benefit_type_code, b.referral_id, b.partner_id
2022: FROM pv_ge_benefits_vl a, pv_referrals_vl b
2023: WHERE a.benefit_id = b.benefit_id AND
2024: b.referral_id = p_referral_id;
2025:
2026: BEGIN