DBA Data[Home] [Help]

APPS.OKL_ACTIVATE_ASSET_PVT dependencies on FA_DEPRN_PERIODS

Line 787: from fa_deprn_periods

783: CURSOR open_period_cur(p_book_type_code IN VARCHAR2) IS
784: select period_name,
785: calendar_period_open_date,
786: calendar_period_close_date
787: from fa_deprn_periods
788: where book_type_code = p_book_type_code
789: and period_close_date is null;
790:
791: open_period_rec open_period_cur%rowtype;

Line 860: from fa_deprn_periods

856: CURSOR open_period_cur(p_book_type_code IN VARCHAR2) IS
857: select period_name,
858: calendar_period_open_date,
859: calendar_period_close_date
860: from fa_deprn_periods
861: where book_type_code = p_book_type_code
862: and period_close_date is null;
863:
864: open_period_rec open_period_cur%rowtype;

Line 1948: fa_deprn_periods fdp,

1944: fbc.prorate_calendar,
1945: fbc.last_period_counter,
1946: fdp.period_name
1947: FROM fa_book_controls fbc,
1948: fa_deprn_periods fdp,
1949: fa_calendar_periods fcp
1950: WHERE fcp.period_name = fdp.period_name
1951: AND fdp.period_counter = (fbc.last_period_counter + 1)
1952: AND fdp.book_type_code = fbc.book_type_code