DBA Data[Home] [Help]

APPS.FA_QUERY_BALANCES_PKG dependencies on FA_DEPRN_PERIODS

Line 453: from fa_deprn_periods dp,

449: select dp.period_counter-1,
450: count(*)
451: into X_dpr_row.period_ctr,
452: h_count
453: from fa_deprn_periods dp,
454: fa_transaction_headers th
455: where dp.book_type_code = X_dpr_row.book
456: and th.date_effective between
457: dp.period_open_date and

Line 1067: from fa_deprn_periods

1063: --bugfix 3666915 starts
1064: begin
1065: select fiscal_year
1066: into h_fy
1067: from fa_deprn_periods
1068: where book_type_code = X_dpr_row.book
1069: and period_counter = h_period_counter;
1070: Exception
1071: when no_data_found then

Line 1614: from fa_deprn_periods

1610: --bugfix 3666915 starts
1611: begin
1612: select fiscal_year
1613: into h_fy
1614: from fa_deprn_periods
1615: where book_type_code = X_dpr_row.book
1616: and period_counter = h_period_counter;
1617: Exception
1618: when no_data_found then