DBA Data[Home] [Help]

APPS.PV_AS_ACCESS_VHUK dependencies on PV_PARTNER_PROFILES

Line 50: pv_partner_profiles PVPP,

46: PTORG.relationship_code
47: FROM
48: hz_relationships CONTACT,
49: hz_relationships PTORG,
50: pv_partner_profiles PVPP,
51: jtf_rs_resource_extns EXTN
52: WHERE EXTN.resource_id = pc_salesforce_id
53: AND EXTN.source_id = CONTACT.party_id
54: AND EXTN.category = 'PARTY'

Line 110: pv_partner_profiles PVPP,

106:
107: SELECT 'PARTNER_OF'
108: FROM
109: hz_relationships CONTACT,
110: pv_partner_profiles PVPP,
111: jtf_rs_resource_extns EXTN,
112: fnd_user fndu
113: WHERE fndu.user_id = fnd_global.user_id
114: AND EXTN.user_id = fndu.user_id