APPS.FUN_TRX_PVT dependencies on XLE_FIRSTPARTY_INFORMATION_V

Line 274: FROM xle_firstparty_information_v le, hz_parties parties

270: l_le_end_dt DATE;
271:
272: CURSOR legal_entity_csr IS
273: SELECT le.le_effective_from, le.le_effective_to
274: FROM xle_firstparty_information_v le, hz_parties parties
275: WHERE parties.party_id = p_party_id
276: AND EXISTS (SELECT 1
277: FROM hz_party_usg_assignments hua
278: WHERE hua.party_id = parties.party_id

Line 2116: FROM xle_firstparty_information_v

2112: IF l_from_le_party_id IS NOT NULL THEN -- 6145670
2113:
2114: SELECT legal_entity_id
2115: INTO l_from_le_id
2116: FROM xle_firstparty_information_v
2117: WHERE party_id = l_from_le_party_id;
2118:
2119: check_invoice_reqd_flag(p_init_party_id => p_initiator_id,
2120: p_init_le_id => l_from_le_id,

Line 4277: FROM xle_firstparty_information_v

4273: l_from_le_party_id := Fun_Tca_Pkg.Get_LE_Id(p_initiator_id, p_trx_date);
4274:
4275: SELECT legal_entity_id
4276: INTO l_from_le_id
4277: FROM xle_firstparty_information_v
4278: WHERE party_id = l_from_le_party_id;
4279: --
4280:
4281: l_from_ou_id := Fun_Tca_Pkg.Get_OU_Id(p_initiator_id, p_trx_date);