APPS.PV_REFERRAL_COMP_PUB dependencies on PV_REFERRALS_B

Line 119: FROM pv_referrals_b

115: CURSOR c_matching_referral IS
116: SELECT referral_id, partner_id,
117: COUNT(*) OVER (PARTITION BY counter) outer_counter
118: FROM (SELECT referral_id, partner_id, 'x' counter
119: FROM pv_referrals_b
120: WHERE order_id = p_order_header_id);
121: */
122:
123: -- -------------------------------------------------------------------

Line 133: FROM pv_referrals_b

129: -- -------------------------------------------------------------------
130: CURSOR c_matching_referral IS
131: SELECT referral_id, partner_id, referral_status, claim_id,
132: partner_cust_account_id
133: FROM pv_referrals_b
134: WHERE order_id = p_order_header_id AND
135: claim_id IS NULL
136: ORDER by creation_date ASC;
137:

Line 148: pv_referrals_b REF,

144: -- -------------------------------------------------------------------
145: CURSOR c_matching_line (pc_referral_id NUMBER) IS
146: SELECT LINE.inventory_item_id
147: FROM pv_referred_products PROD,
148: pv_referrals_b REF,
149: oe_order_lines_all LINE,
150: mtl_item_categories MIC,
151: eni_prod_denorm_hrchy_v DENORM,
152: pv_ge_benefits_vl BENFT

Line 178: FROM pv_referrals_b REF,

174: CURSOR c_matching_referral_2 IS
175: SELECT *
176: FROM (
177: SELECT REF.referral_id, REF.partner_id, REF.partner_cust_account_id
178: FROM pv_referrals_b REF,
179: pv_referred_products PROD,
180: pv_ge_benefits_b BENFT,
181: oe_order_headers_all HEADER,
182: oe_order_lines_all LINE,

Line 212: FROM pv_referrals_b

208: -- Template Cursor
209: -- --------------------------------------------------------------------------
210: CURSOR c_template IS
211: SELECT referral_id, partner_cust_account_id, claim_id, 1 outer_counter
212: FROM pv_referrals_b
213: WHERE referral_id = 1;
214:
215: lc_template c_template%ROWTYPE;
216:

Line 232: FROM pv_referrals_b REF,

228: SELECT REF.referral_id,
229: REF.partner_cust_account_id,
230: REF.claim_id,
231: 1 counter
232: FROM pv_referrals_b REF,
233: pv_referred_products PROD,
234: pv_ge_benefits_b BENFT,
235: oe_order_headers_all HEADER,
236: oe_order_lines_all LINE,

Line 335: UPDATE pv_referrals_b

331:
332: -- -----------------------------------------------------------------
333: -- Associate the order with this referral.
334: -- -----------------------------------------------------------------
335: UPDATE pv_referrals_b
336: SET order_id = p_order_header_id
337: WHERE referral_id = x.referral_id AND
338: order_id IS NULL;
339:

Line 553: FROM pv_referrals_b REF,

549: LINE.flow_status_code,
550: OFFER.qp_list_header_id,
551: REF.referral_id,
552: REF.partner_cust_account_id
553: FROM pv_referrals_b REF,
554: pv_referred_products PROD,
555: pv_ge_benefits_b BENFT,
556: oe_order_headers_all HEADER,
557: oe_order_lines_all LINE,

Line 732: UPDATE pv_referrals_b

728:
729: -- -----------------------------------------------------------------
730: -- Link the claim to the referral and update referral status.
731: -- -----------------------------------------------------------------
732: UPDATE pv_referrals_b
733: SET claim_id = l_claim_id,
734: claim_number = l_claim_number,
735: actual_compensation_amt = l_claim_amount,
736: actual_currency_code = l_claim_rec.currency_code,