DBA Data[Home] [Help]

APPS.IBE_CUSTOMER_ACCT_PVT dependencies on HZ_RELATIONSHIPS

Line 1495: (select subject_id from HZ_RELATIONSHIPS

1491: where party_type = 'PERSON' and party_id = lc_cntct_partyid
1492: union
1493: select party_name from HZ_PARTIES
1494: where party_id =
1495: (select subject_id from HZ_RELATIONSHIPS
1496: where party_id = lc_cntct_partyid and
1497: subject_type = 'PERSON' and object_type = 'ORGANIZATION');
1498:
1499: lc_contact_partyname c_contact_partyname%rowtype;