APPS.FA_MC_UPG1_PKG dependencies on FA_DEPRN_PERIODS

Line 699: fa_deprn_periods dp,

695: dp.fiscal_year,
696: dp.period_counter,
697: dp2.period_counter
698: FROM
699: fa_deprn_periods dp,
700: fa_deprn_periods dp2,
701: fa_deprn_periods dp3,
702: fa_book_controls bc
703: WHERE

Line 700: fa_deprn_periods dp2,

696: dp.period_counter,
697: dp2.period_counter
698: FROM
699: fa_deprn_periods dp,
700: fa_deprn_periods dp2,
701: fa_deprn_periods dp3,
702: fa_book_controls bc
703: WHERE
704: bc.book_type_code = p_book_type_code AND

Line 701: fa_deprn_periods dp3,

697: dp2.period_counter
698: FROM
699: fa_deprn_periods dp,
700: fa_deprn_periods dp2,
701: fa_deprn_periods dp3,
702: fa_book_controls bc
703: WHERE
704: bc.book_type_code = p_book_type_code AND
705: dp3.period_name = l_prior_fa_period AND

Line 716: from fa_deprn_periods dp4

712: dp.period_num = 1 AND
713: */
714: dp.period_num =
715: (select min(period_num)
716: from fa_deprn_periods dp4
717: where dp4.book_type_code = dp.book_type_code
718: and dp4.fiscal_year = dp.fiscal_year) AND
719: dp2.book_type_code = bc.book_type_code AND
720: dp2.period_close_date is NULL;

Line 797: fa_deprn_periods dp2,

793: dp.period_counter,
794: dp2.period_counter
795: INTO l_start_fy, X_start_pc, X_end_pc
796: FROM
797: fa_deprn_periods dp2,
798: fa_deprn_periods dp
799: WHERE dp.book_type_code = p_book_type_code
800: AND dp2.book_type_code = dp.book_type_code
801: AND dp2.period_close_date is null

Line 798: fa_deprn_periods dp

794: dp2.period_counter
795: INTO l_start_fy, X_start_pc, X_end_pc
796: FROM
797: fa_deprn_periods dp2,
798: fa_deprn_periods dp
799: WHERE dp.book_type_code = p_book_type_code
800: AND dp2.book_type_code = dp.book_type_code
801: AND dp2.period_close_date is null
802: AND dp.fiscal_year = dp2.fiscal_year