DBA Data[Home] [Help]

APPS.CSE_FAC_INSERVICE_PKG dependencies on FA_BOOK_CONTROLS

Line 708: FROM fa_book_controls

704: IF nvl(l_deprn_expense_ccid,0) > 0 THEN
705:
706: SELECT accounting_flex_structure
707: INTO l_acc_flex_structure
708: FROM fa_book_controls
709: WHERE book_type_code = l_book_type_code;
710:
711: IF NOT (FND_FLEX_KEYVAL.validate_ccid(
712: appl_short_name => 'SQLGL',

Line 1005: FROM fa_book_controls fbc,

1001: IF l_serial_number is null THEN
1002: BEGIN
1003: SELECT start_date
1004: INTO l_dpis
1005: FROM fa_book_controls fbc,
1006: fa_calendar_periods fcp
1007: WHERE fbc.book_type_code = l_book_type_code
1008: AND fcp.calendar_type = fbc.deprn_calendar
1009: AND trunc(insrv_txn_rec.dpis,'DDD') BETWEEN fcp.start_date AND fcp.end_date;