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 to_char(period_open_date,'dd-mm-yyyy hh24:mi:ss')
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 to_char(period_close_date,'dd-mm-yyyy hh24:mi:ss')

Line 158: from fa_deprn_periods

154:
155: if (h_count > 0) then
156: select to_char(period_close_date,'dd-mm-yyyy hh24:mi:ss')
157: into h_period2_pcd
158: from fa_deprn_periods
159: where book_type_code = h_book and period_name = end_period;
160: end if;
161:
162: /* BUG# 2939771

Line 257: fa_deprn_periods dp,

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