APPS.FA_FAS840_XMLP_PKG dependencies on FA_DEPRN_PERIODS

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 75: FROM FA_DEPRN_PERIODS

71: SELECT period_name,
72: period_counter
73: INTO l_period_name,
74: l_period_PC
75: FROM FA_DEPRN_PERIODS
76: WHERE book_type_code = P_BOOK
77: AND period_name = P_PERIOD1;
78: END IF;
79: Period1_PC := l_period_PC;

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 129: from fa_deprn_periods

125: select period_name,
126: period_counter
127: into l_period_name,
128: l_period_PC
129: from fa_deprn_periods
130: where book_type_code = P_BOOK
131: and period_name = P_PERIOD2;
132: END IF;
133: PERIOD2_PC := l_period_pc;

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;

Line 177: lp_fa_deprn_periods := 'FA_DEPRN_PERIODS';

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;
179: return (TRUE);
180: end;
181: --Functions to refer Oracle report placeholders--