APPS.PV_REFERRAL_COMP_PUB dependencies on PV_PARTNER_PROFILES

Line 1023: FROM pv_partner_profiles a,

1019: -- The following query will always return something.
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: