DBA Data[Home] [Help]

APPS.FA_QUERY_BALANCES_PKG dependencies on FA_DEPRN_PERIODS

Line 442: from fa_deprn_periods dp,

438: select dp.period_counter-1,
439: count(*)
440: into X_dpr_row.period_ctr,
441: h_count
442: from fa_deprn_periods dp,
443: fa_transaction_headers th
444: where dp.book_type_code = X_dpr_row.book
445: and th.date_effective between
446: dp.period_open_date and

Line 1027: from fa_deprn_periods

1023: --bugfix 3666915 starts
1024: begin
1025: select fiscal_year
1026: into h_fy
1027: from fa_deprn_periods
1028: where book_type_code = X_dpr_row.book
1029: and period_counter = h_period_counter;
1030: Exception
1031: when no_data_found then

Line 1516: from fa_deprn_periods

1512: --bugfix 3666915 starts
1513: begin
1514: select fiscal_year
1515: into h_fy
1516: from fa_deprn_periods
1517: where book_type_code = X_dpr_row.book
1518: and period_counter = h_period_counter;
1519: Exception
1520: when no_data_found then