APPS.WSH_ITM_PARTY_SYNC dependencies on HZ_PERSON_PROFILES

Line 110: 'hz_Person_profiles person_profile '||

106: 'hz_cust_accounts acct,'||
107: 'hz_party_sites party_site,'||
108: 'hz_parties party,'||
109: 'hz_locations loc ,'||
110: 'hz_Person_profiles person_profile '||
111: 'WHERE '||
112: ' site_uses.CUST_ACCT_SITE_ID = acct_site.CUST_ACCT_SITE_ID'||
113: ' AND acct_site.PARTY_SITE_ID = party_site.PARTY_SITE_ID'||
114: ' AND party_site.PARTY_ID = party.PARTY_ID'||

Line 299: 'hz_Person_profiles person_profile '||

295: 'hz_party_sites party_site,'||
296: 'hz_party_site_uses site_uses,'||
297: 'hz_parties party,'||
298: 'hz_locations loc, '||
299: 'hz_Person_profiles person_profile '||
300: 'WHERE '||
301: ' party_site.party_id (+) = party.party_id'||
302: ' AND party_site.party_site_id = site_uses.party_site_id (+) '||
303: ' AND party.status in ( ''A'', ''M'', ''D'') '||

Line 1393: hz_Person_profiles hpp

1389: from hz_relationships hr, --TCA view removal Starts
1390: hz_Parties hp,
1391: hz_org_contacts hoc,
1392: hz_cust_account_roles hcar,
1393: hz_Person_profiles hpp
1394: where hr.subject_table_name = 'HZ_PARTIES'
1395: and hr.object_table_name = 'HZ_PARTIES'
1396: and hr.Directional_flag = 'F'
1397: and object_id = l_num_hzpartyID_tab(i)