41: DUAL;
42: FOR C1 IN (SELECT
43: ORGANIZATION_ID
44: FROM
45: MTL_PARAMETERS MP
46: WHERE MASTER_ORGANIZATION_ID = (
47: SELECT
48: MASTER_ORGANIZATION_ID
49: FROM
46: WHERE MASTER_ORGANIZATION_ID = (
47: SELECT
48: MASTER_ORGANIZATION_ID
49: FROM
50: MTL_PARAMETERS
51: WHERE ORGANIZATION_ID = P_ORG_ID )
52: AND MP.ORGANIZATION_ID IN (
53: SELECT
54: ORGANIZATION_ID