APPS.PV_BENFT_STATUS_CHANGE dependencies on PV_PARTNER_PROFILES

Line 1237: pv_partner_profiles b,

1233: A.creation_date,
1234: a.actual_compensation_amt || '' '' || a.currency_code
1235: from
1236: pv_referrals_vl a,
1237: pv_partner_profiles b,
1238: hz_parties c,
1239: jtf_rs_resource_extns pt_cont,
1240: jtf_rs_resource_extns creator,
1241: pv_lookups lkup,

Line 1463: pv_partner_profiles prof,

1459: pc_partner_id number) is
1460: SELECT
1461: usr.user_name
1462: FROM
1463: pv_partner_profiles prof,
1464: hz_relationships pr2,
1465: jtf_rs_resource_extns pj,
1466: fnd_user usr
1467: WHERE