APPS.FARX_CP dependencies on FA_DEPRN_PERIODS

Line 121: from fa_deprn_periods

117: h_mesg_name := 'FA_AMT_SEL_PERIODS';
118:
119: select period_open_date
120: into h_period1_pod
121: from fa_deprn_periods
122: where book_type_code = h_book and period_name = begin_period;
123:
124: select count(*) into h_count
125: from fa_deprn_periods where period_name = end_period

Line 125: from fa_deprn_periods where period_name = end_period

121: from fa_deprn_periods
122: where book_type_code = h_book and period_name = begin_period;
123:
124: select count(*) into h_count
125: from fa_deprn_periods where period_name = end_period
126: and book_type_code = h_book;
127:
128: if (h_count > 0) then
129: select period_close_date

Line 131: from fa_deprn_periods

127:
128: if (h_count > 0) then
129: select period_close_date
130: into h_period2_pcd
131: from fa_deprn_periods
132: where book_type_code = h_book and period_name = end_period;
133: else
134: h_period2_pcd := null;
135: end if;