245: IF P_ALL_ORGS = 1 THEN
246: FOR C1 IN (SELECT
247: ORGANIZATION_ID
248: FROM
249: MTL_PARAMETERS MP
250: WHERE MASTER_ORGANIZATION_ID = (
251: SELECT
252: MASTER_ORGANIZATION_ID
253: FROM
250: WHERE MASTER_ORGANIZATION_ID = (
251: SELECT
252: MASTER_ORGANIZATION_ID
253: FROM
254: MTL_PARAMETERS
255: WHERE ORGANIZATION_ID = LP_ORGANIZATION_ID )
256: AND MP.ORGANIZATION_ID IN (
257: SELECT
258: ORGANIZATION_ID