APPS.FA_SORP_UPG_PKG dependencies on FA_DEPRN_PERIODS

Line 823: fa_deprn_periods fadep,

819: CURSOR c_cal_per
820: IS
821: SELECT fadep.period_counter, facalp.period_name
822: FROM fa_calendar_periods facalp,
823: fa_deprn_periods fadep,
824: fa_book_controls fabkctl
825: WHERE facalp.calendar_type = fabkctl.deprn_calendar
826: AND fabkctl.book_type_code = p_book_type_code
827: AND fadep.book_type_code = fabkctl.book_type_code

Line 1324: from fa_deprn_periods

1320:
1321:
1322:
1323: select period_name into v_period_name
1324: from fa_deprn_periods
1325: where book_type_code = P_FA_BOOK
1326: and period_close_date is null;
1327:
1328: open c_fa_sorp_upg_cagf_hist_cur;

Line 1743: from fa_deprn_periods

1739:
1740:
1741:
1742: select period_name into v_period_name
1743: from fa_deprn_periods
1744: where book_type_code = P_FA_BOOK
1745: and period_close_date is null;
1746:
1747: open c_fa_sorp_upg_cagf_hist_cur;