DBA Data[Home] [Help]

APPS.JL_ZZ_FA_FUNCTIONS_PKG dependencies on FA_MASS_REVALUATIONS

Line 987: FROM fa_mass_revaluations rev,

983:
984: BEGIN
985: SELECT rev.reval_date
986: INTO l_reval_date
987: FROM fa_mass_revaluations rev,
988: fa_deprn_periods dp
989: WHERE dp.period_counter = p_period_counter_from
990: AND dp.book_type_code = p_adj_book_type_code
991: AND dp.book_type_code = rev.book_type_code

Line 1012: FROM fa_mass_revaluations rev,

1008:
1009: BEGIN
1010: SELECT max(rev.reval_date)
1011: INTO l_reval_date
1012: FROM fa_mass_revaluations rev,
1013: fa_deprn_periods dp
1014: WHERE dp.period_counter between p_period_counter_from and p_period_counter_to
1015: AND dp.book_type_code = p_adj_book_type_code
1016: AND dp.book_type_code = rev.book_type_code