DBA Data[Home] [Help]

APPS.PA_CC_IDENT dependencies on XLE_ENTITY_PROFILES

Line 1745: l_legal_entity_id XLE_ENTITY_PROFILES.LEGAL_ENTITY_ID%TYPE;

1741: FUNCTION GET_ORG_LEGAL_ENTITY( p_org_id NUMBER,
1742: p_organization_id PA_EXPENDITURES_ALL.INCURRED_BY_ORGANIZATION_ID%TYPE)
1743: RETURN NUMBER IS
1744:
1745: l_legal_entity_id XLE_ENTITY_PROFILES.LEGAL_ENTITY_ID%TYPE;
1746:
1747: BEGIN
1748: SELECT h.default_legal_context_id
1749: INTO l_legal_entity_id

Line 1751: xle_entity_profiles xep,

1747: BEGIN
1748: SELECT h.default_legal_context_id
1749: INTO l_legal_entity_id
1750: FROM hr_operating_units h,
1751: xle_entity_profiles xep,
1752: pa_implementations_all i
1753: WHERE i.org_id = p_org_id
1754: AND i.org_id = h.organization_id
1755: AND h.default_legal_context_id = xep.legal_entity_id;