APPS.FA_ASSET_VAL_PVT dependencies on FA_DEPRN_PERIODS

Line 1788: from fa_deprn_periods pdp,

1784: end if;
1785:
1786: select count(*)
1787: into l_count
1788: from fa_deprn_periods pdp,
1789: fa_deprn_periods adp
1790: where pdp.book_type_code = p_book_type_code
1791: and pdp.book_type_code = adp.book_type_code
1792: and pdp.period_counter > adp.period_counter

Line 1789: fa_deprn_periods adp

1785:
1786: select count(*)
1787: into l_count
1788: from fa_deprn_periods pdp,
1789: fa_deprn_periods adp
1790: where pdp.book_type_code = p_book_type_code
1791: and pdp.book_type_code = adp.book_type_code
1792: and pdp.period_counter > adp.period_counter
1793: and l_prior_date_effective between pdp.period_open_date

Line 4632: ,fa_deprn_periods fdp

4628: )
4629: is
4630: select fdp.calendar_period_close_date
4631: from fa_book_controls fbc
4632: ,fa_deprn_periods fdp
4633: where fbc.book_type_code = fdp.book_type_code
4634: and fdp.period_counter = fbc.last_period_counter+1
4635: and fbc.book_type_code = p_book_type_code;
4636:

Line 4848: ,fa_deprn_periods fdp

4844: )
4845: is
4846: select fdp.calendar_period_close_date
4847: from fa_book_controls fbc
4848: ,fa_deprn_periods fdp
4849: where fbc.book_type_code = fdp.book_type_code
4850: and fdp.period_counter = fbc.last_period_counter+1
4851: and fbc.book_type_code = p_book_type_code;
4852:

Line 5990: ,fa_deprn_periods fdp

5986: )
5987: is
5988: select fdp.calendar_period_close_date
5989: from fa_book_controls fbc
5990: ,fa_deprn_periods fdp
5991: where fbc.book_type_code = fdp.book_type_code
5992: and fdp.period_counter = fbc.last_period_counter+1
5993: and fbc.book_type_code = p_book_type_code;
5994:

Line 6353: FA_DEPRN_PERIODS FADP,

6349: SELECT count(*)
6350: INTO l_imp_exists
6351: FROM
6352: FA_TRANSACTION_HEADERS FATH,
6353: FA_DEPRN_PERIODS FADP,
6354: FA_FISCAL_YEAR FAFY
6355: WHERE FATH.BOOK_TYPE_CODE = p_asset_hdr_rec.BOOK_TYPE_CODE
6356: AND FAFY.FISCAL_YEAR_NAME = l_fiscal_year
6357: AND FATH.ASSET_ID = p_asset_hdr_rec.ASSET_ID