APPS.EGO_ITEM_PUB dependencies on MTL_PARAMETERS

Line 3644: FROM MTL_PARAMETERS MP

3640: FUNCTION Get_Master_Organization_Id(P_ORGANIZATION_ID IN NUMBER) RETURN NUMBER IS
3641: L_MASTER_ORGANIZATION_ID NUMBER;
3642: BEGIN
3643: SELECT MP.MASTER_ORGANIZATION_ID INTO L_MASTER_ORGANIZATION_ID
3644: FROM MTL_PARAMETERS MP
3645: WHERE MP.ORGANIZATION_ID = P_ORGANIZATION_ID;
3646:
3647: RETURN L_MASTER_ORGANIZATION_ID;
3648:

Line 4361: FROM MTL_PARAMETERS

4357: BEGIN
4358: IF p_organization_id IS NULL THEN
4359: IF p_organization_code IS NOT NULL THEN
4360: SELECT ORGANIZATION_ID INTO l_organization_id
4361: FROM MTL_PARAMETERS
4362: WHERE ORGANIZATION_CODE = p_organization_code;
4363: ELSE
4364: RAISE INVALID_ORG;
4365: END IF;

Line 4368: FROM MTL_PARAMETERS

4364: RAISE INVALID_ORG;
4365: END IF;
4366: ELSE
4367: SELECT ORGANIZATION_ID INTO l_organization_id
4368: FROM MTL_PARAMETERS
4369: WHERE ORGANIZATION_ID = p_organization_id;
4370: END IF;
4371:
4372: EXCEPTION