DBA Data[Home] [Help]

APPS.IBE_CUSTOMER_ACCT_PVT dependencies on HZ_RELATIONSHIPS

Line 1492: (select subject_id from HZ_RELATIONSHIPS

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