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