APPS.FUN_OPEN_INTERFACE_PKG dependencies on XLE_FIRSTPARTY_INFORMATION_V

Line 60: FROM xle_firstparty_information_v

56: and u.party_id = p.party_id);
57:
58: Cursor c_Le_Id_per_name(l_From_le_name IN VARCHAR2) IS
59: SELECT legal_entity_id
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

Line 94: FROM xle_firstparty_information_v

90: WHERE trx_type_id = l_Trx_type_id;
91:
92: Cursor c_from_le_id (l_party_id IN NUMBER) IS --3603338 new cursor
93: SELECT legal_entity_id
94: FROM xle_firstparty_information_v
95: WHERE party_id = l_party_id;
96:
97: BEGIN
98:

Line 308: FROM xle_firstparty_information_v

304:
305:
306: Cursor c_Le_Id_per_name(l_to_le_name IN VARCHAR2) IS
307: SELECT legal_entity_id
308: FROM xle_firstparty_information_v
309: WHERE name=l_to_le_name;
310:
311:
312: /*SELECT hp.party_id

Line 327: FROM xle_firstparty_information_v

323: WHERE legal_entity_id = l_to_le_id
324: AND ledger_category_code = 'PRIMARY';
325: Cursor c_from_le_id (l_party_id IN NUMBER) IS --3603338 new cursor
326: SELECT legal_entity_id
327: FROM xle_firstparty_information_v
328: WHERE party_id = l_party_id;
329:
330: BEGIN
331: