92: IF P_ALL_ORGS = 1 THEN
93: FOR C1 IN (SELECT
94: ORGANIZATION_ID
95: FROM
96: MTL_PARAMETERS MP
97: WHERE MASTER_ORGANIZATION_ID = (
98: SELECT
99: MASTER_ORGANIZATION_ID
100: FROM
97: WHERE MASTER_ORGANIZATION_ID = (
98: SELECT
99: MASTER_ORGANIZATION_ID
100: FROM
101: MTL_PARAMETERS
102: WHERE ORGANIZATION_ID = LP_ORG_ID )
103: AND MP.ORGANIZATION_ID IN (
104: SELECT
105: ORGANIZATION_ID