DBA Data[Home] [Help]

APPS.FA_RETMT_TAX_REG_RPT_PKG dependencies on FA_DEPRN_PERIODS

Line 86: FROM fa_deprn_periods fadp

82:
83: IF (P_FROM_PERIOD IS NOT NULL) THEN
84: SELECT TRUNC (fadp.calendar_period_open_date)
85: INTO period_from
86: FROM fa_deprn_periods fadp
87: WHERE fadp.book_type_code = p_book_name
88: AND fadp.period_name = p_from_period;
89: END IF;
90:

Line 95: FROM fa_deprn_periods fadp

91:
92: IF (P_TO_PERIOD IS NOT NULL) THEN
93: SELECT TRUNC (fadp.calendar_period_close_date)
94: INTO period_to
95: FROM fa_deprn_periods fadp
96: WHERE fadp.book_type_code = p_book_name
97: AND fadp.period_name = p_to_period;
98: END IF;
99:

Line 176: FROM fa_deprn_periods fadp

172:
173: BEGIN
174: SELECT TRUNC (fadp.calendar_period_open_date)
175: INTO lp_from_date
176: FROM fa_deprn_periods fadp
177: WHERE fadp.book_type_code = p_book_name
178: AND fadp.period_name = p_from_period;
179: EXCEPTION
180: WHEN OTHERS THEN

Line 194: FROM fa_deprn_periods fadp

190:
191: BEGIN
192: SELECT TRUNC (fadp.calendar_period_close_date)
193: INTO lp_to_date
194: FROM fa_deprn_periods fadp
195: WHERE fadp.book_type_code = p_book_name
196: AND fadp.period_name = p_to_period;
197: EXCEPTION
198: WHEN OTHERS THEN