APPS.FA_FAS402_XMLP_PKG dependencies on FA_DEPRN_PERIODS

Line 61: FROM FA_DEPRN_PERIODS_MRC_V

57: SELECT period_name,
58: period_counter
59: INTO l_period_name,
60: l_period_PC
61: FROM FA_DEPRN_PERIODS_MRC_V
62: WHERE book_type_code = P_BOOK
63: AND period_name = P_PERIOD1;
64: ELSE
65: SELECT period_name,

Line 69: FROM FA_DEPRN_PERIODS

65: SELECT period_name,
66: period_counter
67: INTO l_period_name,
68: l_period_PC
69: FROM FA_DEPRN_PERIODS
70: WHERE book_type_code = P_BOOK
71: AND period_name = P_PERIOD1;
72: END IF;
73: Period1_PC := l_period_PC;

Line 120: FROM FA_DEPRN_PERIODS_MRC_V

116: SELECT period_name,
117: period_counter
118: INTO l_period_name,
119: l_period_PC
120: FROM FA_DEPRN_PERIODS_MRC_V
121: WHERE book_type_code = P_BOOK
122: AND period_name = P_PERIOD2;
123: ELSE
124: SELECT period_name,

Line 128: FROM FA_DEPRN_PERIODS

124: SELECT period_name,
125: period_counter
126: INTO l_period_name,
127: l_period_PC
128: FROM FA_DEPRN_PERIODS
129: WHERE book_type_code = P_BOOK
130: AND period_name = P_PERIOD2;
131: END IF;
132: Period2_PC := l_period_PC;

Line 181: lp_fa_deprn_periods := 'FA_DEPRN_PERIODS_MRC_V';

177: lp_fa_deprn_summary := 'FA_DEPRN_SUMMARY_MRC_V';
178: lp_fa_deprn_detail := 'FA_DEPRN_DETAIL_MRC_V';
179: lp_fa_books := 'FA_BOOKS_MRC_V';
180: lp_fa_book_controls := 'FA_BOOK_CONTROLS_MRC_V';
181: lp_fa_deprn_periods := 'FA_DEPRN_PERIODS_MRC_V';
182: ELSE
183: lp_fa_deprn_summary := 'FA_DEPRN_SUMMARY';
184: lp_fa_deprn_detail := 'FA_DEPRN_DETAIL';
185: lp_fa_books := 'FA_BOOKS';

Line 187: lp_fa_deprn_periods := 'FA_DEPRN_PERIODS';

183: lp_fa_deprn_summary := 'FA_DEPRN_SUMMARY';
184: lp_fa_deprn_detail := 'FA_DEPRN_DETAIL';
185: lp_fa_books := 'FA_BOOKS';
186: lp_fa_book_controls := 'FA_BOOK_CONTROLS';
187: lp_fa_deprn_periods := 'FA_DEPRN_PERIODS';
188: END IF;
189: return (TRUE);
190: end;
191: --Functions to refer Oracle report placeholders--