74: ,FROM_RULE
75: ,TO_RULE
76: FROM
77: FA_MASS_CHANGES MCH,
78: FA_METHODS FM,
79: FA_METHODS TM,
80: FA_BOOK_CONTROLS BC
81: --WHERE MCH.MASS_CHANGE_ID = P_MASS_CHANGE_ID
82: WHERE MCH.MASS_CHANGE_ID = P_MASS_CHANGE_ID1
75: ,TO_RULE
76: FROM
77: FA_MASS_CHANGES MCH,
78: FA_METHODS FM,
79: FA_METHODS TM,
80: FA_BOOK_CONTROLS BC
81: --WHERE MCH.MASS_CHANGE_ID = P_MASS_CHANGE_ID
82: WHERE MCH.MASS_CHANGE_ID = P_MASS_CHANGE_ID1
83: AND FM.METHOD_CODE (+) = MCH.FROM_METHOD_CODE
171: TEMP
172: FROM
173: FA_BOOK_CONTROLS BC,
174: FA_BOOKS BK,
175: FA_METHODS ME
176: WHERE BK.BOOK_TYPE_CODE = BC.BOOK_TYPE_CODE
177: AND BK.ASSET_ID = ASSET_ID
178: AND BK.DATE_INEFFECTIVE IS NULL
179: AND BC.DISTRIBUTION_SOURCE_BOOK = C_BOOK
223: TEMP
224: FROM
225: FA_BOOK_CONTROLS BC,
226: FA_BOOKS BK,
227: FA_METHODS ME
228: WHERE BK.BOOK_TYPE_CODE = BC.DISTRIBUTION_SOURCE_BOOK
229: AND BK.ASSET_ID = ASSET_ID
230: AND BK.DATE_INEFFECTIVE IS NULL
231: AND BC.BOOK_TYPE_CODE = C_BOOK