APPS.FUN_OPEN_INTERFACE_PKG dependencies on HZ_PARTY_USG_ASSIGNMENTS

Line 54: and exists (select u.party_usg_assignment_id from hz_party_usg_assignments u

50: SELECT p.party_id
51: FROM hz_parties p
52: WHERE p.party_name = l_initiator_name
53: and p.party_type='ORGANIZATION'
54: and exists (select u.party_usg_assignment_id from hz_party_usg_assignments u
55: where u.party_usage_code = 'INTERCOMPANY_ORG'
56: and u.party_id = p.party_id);
57:
58: Cursor c_Le_Id_per_name(l_From_le_name IN VARCHAR2) IS

Line 301: and exists (select u.party_usg_assignment_id from hz_party_usg_assignments u

297: SELECT p.party_id
298: FROM hz_parties p
299: WHERE p.party_name = l_recipient_name
300: and p.party_type='ORGANIZATION'
301: and exists (select u.party_usg_assignment_id from hz_party_usg_assignments u
302: where u.party_usage_code = 'INTERCOMPANY_ORG'
303: and u.party_id = p.party_id);
304:
305: