APPS.FA_FASRVPVW_XMLP_PKG dependencies on FA_MASS_REVALUATIONS

Line 29: FA_MASS_REVALUATIONS

25: SELECT
26: BOOK_TYPE_CODE
27: INTO L_BOOK
28: FROM
29: FA_MASS_REVALUATIONS
30: WHERE MASS_REVAL_ID = P_MASS_REVAL_ID1;
31: IF (NOT FA_CACHE_PKG.FAZCBC(L_BOOK)) THEN
32: RAISE REVAL_ERR;
33: END IF;

Line 175: FA_MASS_REVALUATIONS

171: END BEFOREREPORT;
172: FUNCTION AFTERREPORT RETURN BOOLEAN IS
173: BEGIN
174: UPDATE
175: FA_MASS_REVALUATIONS
176: SET
177: STATUS = 'PREVIEWED'
178: WHERE MASS_REVAL_ID = P_MASS_REVAL_ID1;
179: DELETE FROM FA_MASS_REVAL_REP_ITF

Line 247: FA_MASS_REVALUATIONS MR,

243: MR.DEFAULT_MAX_FULLY_RSVD_REVALS,
244: SOB.CURRENCY_CODE
245: INTO L_DESCRIPTION,L_BOOK_TYPE_CODE,TEMP_DEFAULT_RFRF,L_DEFAULT_LEF,L_DEFAULT_LEC,L_DEFAULT_MFRR,L_CURRENCY_CODE
246: FROM
247: FA_MASS_REVALUATIONS MR,
248: FA_BOOK_CONTROLS BC,
249: GL_SETS_OF_BOOKS SOB
250: WHERE MR.MASS_REVAL_ID = P_MASS_REVAL_ID1
251: AND MR.BOOK_TYPE_CODE = BC.BOOK_TYPE_CODE