DBA Data[Home] [Help]

APPS.FA_FAS860_XMLP_PKG dependencies on FA_METHODS

Line 78: FA_METHODS FM,

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

Line 79: FA_METHODS TM,

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

Line 175: FA_METHODS ME

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

Line 227: FA_METHODS ME

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