APPS.FARX_RT dependencies on FA_DEPRN_PERIODS

Line 143: from fa_deprn_periods

139: h_mesg_name := 'FA_AMT_SEL_PERIODS';
140:
141: select period_open_date --Bug#9491496
142: into h_period1_pod
143: from fa_deprn_periods
144: where book_type_code = h_book and period_name = begin_period;
145:
146: /* BUG# 2939771
147:

Line 152: from fa_deprn_periods where period_name = end_period

148: h_period1_pod_char := 'to_date(''' || h_period1_pod || ''',''dd-mm-yyyy hh24:mi:ss'')';
149: */
150:
151: select count(*) into h_count
152: from fa_deprn_periods where period_name = end_period
153: and book_type_code = h_book;
154:
155: if (h_count > 0) then
156: select period_close_date --Bug#9491496

Line 158: from fa_deprn_periods

154:
155: if (h_count > 0) then
156: select period_close_date --Bug#9491496
157: into h_period2_pcd
158: from fa_deprn_periods
159: where book_type_code = h_book and period_name = end_period;
160: else
161: h_period2_pcd := null;
162: end if;

Line 260: fa_deprn_periods dp,

256: fa_books books,
257: fa_retirements ret,
258: fa_transaction_headers th,
259: fa_deprn_detail dd,
260: fa_deprn_periods dp,
261: fa_categories cat';
262:
263: -- parameter where clause --
264: