DBA Data[Home] [Help]

APPS.IGI_IAC_DEPRN_PKG dependencies on FA_BOOK_CONTROLS

Line 285: FROM fa_book_controls

281:
282: /* Bug 2434532 vgadde 28/06/2002 Start(1) */
283: CURSOR c_get_deprn_calendar IS
284: SELECT deprn_calendar
285: FROM fa_book_controls
286: WHERE book_type_code like p_book_type_code;
287:
288: CURSOR c_get_periods_in_year(p_calendar_type fa_calendar_types.calendar_type%TYPE) IS
289: SELECT number_per_fiscal_year

Line 1171: FA_BOOK_CONTROLS bc

1167: nvl(DEPRN_EXPENSE_ACCOUNT_CCID, -1),
1168: nvl(DEPRN_RESERVE_ACCOUNT_CCID, -1),
1169: bc.accounting_flex_structure
1170: FROM FA_DISTRIBUTION_ACCOUNTS da,
1171: FA_BOOK_CONTROLS bc
1172: WHERE bc.book_type_code = p_book_type_code
1173: AND da.book_type_code = bc.book_type_code
1174: AND da.distribution_id = c_distribution_id;
1175:

Line 1363: FROM fa_book_controls

1359: -- get the flex_num and default CCID
1360:
1361: SELECT accounting_flex_structure, flexbuilder_defaults_ccid
1362: into l_flex_num, l_default_ccid
1363: FROM fa_book_controls
1364: WHERE book_type_code = p_book_type_code ;
1365:
1366: IF (l_adj_type(l_loop_count) = 'COST') THEN
1367: -- get the COST