DBA Data[Home] [Help]

APPS.FA_FAS840_XMLP_PKG dependencies on FA_DEPRN_PERIODS_MRC_V

Line 67: FROM FA_DEPRN_PERIODS_MRC_V

63: SELECT period_name,
64: period_counter
65: INTO l_period_name,
66: l_period_PC
67: FROM FA_DEPRN_PERIODS_MRC_V
68: WHERE book_type_code = P_BOOK
69: AND period_name = P_PERIOD1;
70: ELSE
71: SELECT period_name,

Line 121: from fa_deprn_periods_mrc_v

117: select period_name,
118: period_counter
119: into l_period_name,
120: l_period_PC
121: from fa_deprn_periods_mrc_v
122: where book_type_code = P_BOOK
123: and period_name = P_PERIOD2;
124: ELSE
125: select period_name,

Line 174: lp_fa_deprn_periods := 'FA_DEPRN_PERIODS_MRC_V';

170: END IF;
171: IF upper(p_mrcsobtype) = 'R'
172: THEN
173: lp_fa_books := 'FA_BOOKS_MRC_V';
174: lp_fa_deprn_periods := 'FA_DEPRN_PERIODS_MRC_V';
175: ELSE
176: lp_fa_books := 'FA_BOOKS';
177: lp_fa_deprn_periods := 'FA_DEPRN_PERIODS';
178: END IF;