APPS.FUN_TRX_PVT dependencies on XLE_FIRSTPARTY_INFORMATION_V

Line 321: FROM xle_firstparty_information_v le, hz_parties parties

317: l_le_end_dt DATE;
318:
319: CURSOR legal_entity_csr IS
320: SELECT le.le_effective_from, le.le_effective_to
321: FROM xle_firstparty_information_v le, hz_parties parties
322: WHERE parties.party_id = p_party_id
323: AND EXISTS (SELECT 1
324: FROM hz_party_usg_assignments hua
325: WHERE hua.party_id = parties.party_id

Line 2228: FROM xle_firstparty_information_v

2224: IF l_from_le_party_id IS NOT NULL THEN -- 6145670
2225:
2226: SELECT legal_entity_id
2227: INTO l_from_le_id
2228: FROM xle_firstparty_information_v
2229: WHERE party_id = l_from_le_party_id;
2230:
2231: check_invoice_reqd_flag(p_init_party_id => p_initiator_id,
2232: p_init_le_id => l_from_le_id,

Line 4573: FROM xle_firstparty_information_v

4569: l_from_le_party_id := Fun_Tca_Pkg.Get_LE_Id(p_initiator_id, p_trx_date);
4570:
4571: SELECT legal_entity_id
4572: INTO l_from_le_id
4573: FROM xle_firstparty_information_v
4574: WHERE party_id = l_from_le_party_id;
4575: --
4576:
4577: l_from_ou_id := Fun_Tca_Pkg.Get_OU_Id(p_initiator_id, p_trx_date);