DBA Data[Home] [Help]

APPS.FA_FAS420_XMLP_PKG dependencies on FA_DEPRN_PERIODS

Line 59: FROM FA_DEPRN_PERIODS_MRC_V

55: INTO l_period_PC,
56: l_period_POD,
57: l_period_PCD,
58: l_period_FY
59: FROM FA_DEPRN_PERIODS_MRC_V
60: WHERE book_type_code = P_BOOK
61: AND period_name = P_PERIOD1;
62: else
63: SELECT period_counter,

Line 71: FROM FA_DEPRN_PERIODS

67: INTO l_period_PC,
68: l_period_POD,
69: l_period_PCD,
70: l_period_FY
71: FROM FA_DEPRN_PERIODS
72: WHERE book_type_code = P_BOOK
73: AND period_name = P_PERIOD1;
74: end if;
75: Period1_POD := l_period_POD;

Line 98: FROM FA_DEPRN_PERIODS_MRC_V

94: INTO l_period_PC,
95: l_period_POD,
96: l_period_PCD,
97: l_period_FY
98: FROM FA_DEPRN_PERIODS_MRC_V
99: WHERE book_type_code = P_BOOK
100: AND period_name = P_PERIOD2;
101: else
102: SELECT period_counter,

Line 110: FROM FA_DEPRN_PERIODS

106: INTO l_period_PC,
107: l_period_POD,
108: l_period_PCD,
109: l_period_FY
110: FROM FA_DEPRN_PERIODS
111: WHERE book_type_code = P_BOOK
112: AND period_name = P_PERIOD2;
113: end if;
114: Period2_POD := l_period_POD;

Line 145: lp_fa_deprn_periods := 'FA_DEPRN_PERIODS_MRC_V';

141: THEN
142: lp_fa_book_controls := 'FA_BOOK_CONTROLS_MRC_V';
143: lp_fa_books := 'FA_BOOKS_MRC_V';
144: lp_fa_adjustments := 'FA_ADJUSTMENTS_MRC_V';
145: lp_fa_deprn_periods := 'FA_DEPRN_PERIODS_MRC_V';
146: lp_fa_deprn_summary := 'FA_DEPRN_SUMMARY_MRC_V';
147: lp_fa_deprn_detail := 'FA_DEPRN_DETAIL_MRC_V';
148: ELSE
149: lp_fa_book_controls := 'FA_BOOK_CONTROLS';

Line 152: lp_fa_deprn_periods := 'FA_DEPRN_PERIODS';

148: ELSE
149: lp_fa_book_controls := 'FA_BOOK_CONTROLS';
150: lp_fa_books := 'FA_BOOKS';
151: lp_fa_adjustments := 'FA_ADJUSTMENTS';
152: lp_fa_deprn_periods := 'FA_DEPRN_PERIODS';
153: lp_fa_deprn_summary := 'FA_DEPRN_SUMMARY';
154: lp_fa_deprn_detail := 'FA_DEPRN_DETAIL';
155: END IF;
156: return (TRUE);