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 HZ_CUST_ACCOUNTS

Line 183: hz_cust_accounts ACCOUNT,

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,
185: eni_prod_denorm_hrchy_v DENORM
186: WHERE BENFT.additional_info_1 = p_offer_id AND
187: BENFT.benefit_id = REF.benefit_id AND

Line 237: hz_cust_accounts ACCOUNT,

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,
239: eni_prod_denorm_hrchy_v DENORM
240: WHERE BENFT.additional_info_1 = :p_offer_id AND
241: BENFT.benefit_id = REF.benefit_id AND

Line 1024: hz_cust_accounts b

1020: -- --------------------------------------------------------------------------
1021: CURSOR c IS
1022: SELECT MIN(cust_account_id) cust_account_id
1023: FROM pv_partner_profiles a,
1024: hz_cust_accounts b
1025: WHERE a.partner_id = p_partner_id AND
1026: a.partner_party_id = b.party_id;
1027:
1028: l_partner_account_id NUMBER;