eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PV_REFERRAL_COMP_PUB dependencies on PV_GE_BENEFITS_B

Line 180: pv_ge_benefits_b BENFT,

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,
183: hz_cust_accounts ACCOUNT,
184: mtl_item_categories MIC,

Line 234: pv_ge_benefits_b BENFT,

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,
237: hz_cust_accounts ACCOUNT,
238: mtl_item_categories MIC,

Line 482: pv_ge_benefits_b BENFT

478: REF.partner_id,
479: BENFT.additional_info_1 offer_id,
480: BENFT.benefit_id
481: FROM pv_referrals_vl REF,
482: pv_ge_benefits_b BENFT
483: WHERE BENFT.benefit_id = REF.benefit_id AND
484: REF.order_id > 0 AND
485: REF.claim_id IS NULL;
486:

Line 555: pv_ge_benefits_b BENFT,

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,
558: mtl_item_categories MIC,
559: eni_prod_denorm_hrchy_v DENORM,

Line 958: UPDATE pv_ge_benefits_b

954: ELSE
955: l_benefit_status_code := 'FAILED_VALIDATION';
956: END IF;
957:
958: UPDATE pv_ge_benefits_b
959: SET benefit_status_code = l_benefit_status_code
960: WHERE additional_info_1 = p_offer_id;
961:
962: -------------------- Exception --------------------------