APPS.FUN_OPEN_INTERFACE_PKG dependencies on HZ_PARTIES

Line 51: FROM hz_parties p

47: l_From_Ledger_id_per_le fun_interface_batches.from_ledger_id%type;
48:
49: Cursor c_Init_id_per_name(l_initiator_name IN VARCHAR2) IS
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'

Line 64: FROM hz_parties hp, hz_code_assignments hca

60: FROM xle_firstparty_information_v
61: WHERE name=l_from_le_name;
62:
63: /*SELECT hp.party_id
64: FROM hz_parties hp, hz_code_assignments hca
65: WHERE hp.party_name = l_From_Le_name
66: and hca.owner_table_name like 'HZ_PARTIES'
67: and hca.owner_table_id = hp.party_id
68: and hca.class_code like 'LEGAL_ENTITY'

Line 66: and hca.owner_table_name like 'HZ_PARTIES'

62:
63: /*SELECT hp.party_id
64: FROM hz_parties hp, hz_code_assignments hca
65: WHERE hp.party_name = l_From_Le_name
66: and hca.owner_table_name like 'HZ_PARTIES'
67: and hca.owner_table_id = hp.party_id
68: and hca.class_code like 'LEGAL_ENTITY'
69: and hca.class_category like 'LEGAL_FUNCTION';*/
70:

Line 298: FROM hz_parties p

294: l_To_Ledger_id_per_le fun_interface_headers.to_ledger_id%type;
295:
296: Cursor c_reci_id_per_name(l_recipient_name IN VARCHAR2) IS
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'

Line 313: FROM hz_parties hp, hz_code_assignments hca

309: WHERE name=l_to_le_name;
310:
311:
312: /*SELECT hp.party_id
313: FROM hz_parties hp, hz_code_assignments hca
314: WHERE hp.party_name = l_to_Le_name
315: and hca.owner_table_name like 'HZ_PARTIES'
316: and hca.owner_table_id = hp.party_id;
317: and hca.class_code like 'LEGAL_ENTITY'

Line 315: and hca.owner_table_name like 'HZ_PARTIES'

311:
312: /*SELECT hp.party_id
313: FROM hz_parties hp, hz_code_assignments hca
314: WHERE hp.party_name = l_to_Le_name
315: and hca.owner_table_name like 'HZ_PARTIES'
316: and hca.owner_table_id = hp.party_id;
317: and hca.class_code like 'LEGAL_ENTITY'
318: and hca.class_category like 'LEGAL_FUNCTION';*/
319: