DBA Data[Home] [Help]

APPS.CSE_FAC_INSERVICE_PKG dependencies on FA_BOOK_CONTROLS

Line 695: FROM fa_book_controls

691: IF nvl(l_deprn_expense_ccid,0) > 0 THEN
692:
693: SELECT accounting_flex_structure
694: INTO l_acc_flex_structure
695: FROM fa_book_controls
696: WHERE book_type_code = l_book_type_code;
697:
698: IF NOT (FND_FLEX_KEYVAL.validate_ccid(
699: appl_short_name => 'SQLGL',

Line 986: FROM fa_book_controls fbc,

982:
983: IF l_serial_number is null THEN
984: SELECT start_date
985: INTO l_dpis
986: FROM fa_book_controls fbc,
987: fa_calendar_periods fcp
988: WHERE fbc.book_type_code = l_book_type_code
989: AND fcp.calendar_type = fbc.deprn_calendar
990: AND insrv_txn_rec.dpis BETWEEN fcp.start_date AND fcp.end_date;