APPS.IGI_IAC_COMMON_UTILS dependencies on FA_BOOK_CONTROLS

Line 67: fa_book_controls bc

63: p_prd_rec.period_end_date, p_prd_rec.period_counter , p_prd_rec.fiscal_year
64: FROM fa_fiscal_year fy ,
65: fa_calendar_types ct ,
66: fa_calendar_periods cp,
67: fa_book_controls bc
68: WHERE ct.fiscal_year_name = fy.fiscal_year_name
69: AND bc.book_type_code = P_book_type_code
70: AND ct.calendar_type = bc.deprn_Calendar
71: AND fy.fiscal_year = decode( mod ( P_period_counter , ct.number_per_fiscal_year ) , 0 ,

Line 119: fa_book_controls bc

115: p_prd_rec.period_end_date, p_prd_rec.period_counter , p_prd_rec.fiscal_year
116: FROM fa_fiscal_year fy ,
117: fa_calendar_types ct ,
118: fa_calendar_periods cp ,
119: fa_book_controls bc
120: WHERE ct.fiscal_year_name = fy.fiscal_year_name
121: AND bc.book_type_code = P_book_type_code
122: AND ct.calendar_type = bc.deprn_Calendar
123: AND P_date between cp.start_date and cp.end_Date

Line 167: fa_book_controls bc

163: p_prd_rec.period_end_date, p_prd_rec.period_counter , p_prd_rec.fiscal_year
164: FROM fa_fiscal_year fy ,
165: fa_calendar_types ct ,
166: fa_calendar_periods cp ,
167: fa_book_controls bc
168: WHERE ct.fiscal_year_name = fy.fiscal_year_name
169: AND bc.book_type_code = P_book_type_code
170: AND ct.calendar_type = bc.deprn_Calendar
171: AND cp.calendar_type = ct.calendar_type

Line 709: FROM fa_Calendar_types ct , fa_book_controls bc

705: END IF;
706:
707: SELECT ct.calendar_type , ct.fiscal_year_name
708: INTO l_calendar , l_fiscal_year_name
709: FROM fa_Calendar_types ct , fa_book_controls bc
710: WHERE ct.calendar_type = bc.deprn_calendar
711: AND bc.book_type_Code = P_book_type_Code ;
712:
713: SELECT fy.start_Date

Line 838: fa_book_controls bc

834: l_prd_rec.period_end_date, l_prd_rec.period_counter , l_prd_rec.fiscal_year
835: FROM fa_fiscal_year fy ,
836: fa_calendar_types ct ,
837: fa_calendar_periods cp ,
838: fa_book_controls bc
839: WHERE ct.fiscal_year_name = fy.fiscal_year_name
840: AND bc.book_type_code = X_book_type_code
841: AND ct.calendar_type = bc.deprn_Calendar
842: AND l_dpis between cp.start_date and cp.end_Date

Line 937: from fa_book_controls

933: l_path_name VARCHAR2(150) ;
934:
935: Cursor dep_cal is
936: select deprn_calendar
937: from fa_book_controls
938: where book_type_code = X_book_type_code;
939:
940: Cursor start_end_dat(cp_dep_cal varchar2) is
941: select start_date , end_date

Line 1008: fa_book_controls bc

1004: RETURN BOOLEAN IS
1005: CURSOR IAC_book IS
1006: SELECT 'X'
1007: FROM igi_iac_book_Controls ibc ,
1008: fa_book_controls bc
1009: WHERE bc.book_type_code = ibc.book_type_code
1010: AND bc.date_ineffective IS NULL
1011: AND bc.book_type_code = X_book_type_code;
1012:

Line 1178: FROM fa_book_controls bc

1174: )
1175: RETURN BOOLEAN IS
1176: Cursor get_gl_info(p_book_type_code Varchar2) is
1177: SELECT bc.accounting_flex_structure, bc.set_of_books_id
1178: FROM fa_book_controls bc
1179: WHERE bc.book_type_code = p_book_type_code
1180: AND bc.date_ineffective IS NULL ;
1181: Cursor get_curr (p_set_of_books_id Number) is
1182: SELECT currency_code

Line 1329: FROM fa_book_controls

1325: Default_Account IN OUT NOCOPY NUMBER )
1326: RETURN BOOLEAN IS
1327: Cursor get_default (p_book_type_code Varchar2) IS
1328: SELECT flexbuilder_defaults_ccid
1329: FROM fa_book_controls
1330: WHERE book_type_code = p_book_type_code;
1331: l_path_name VARCHAR2(150);
1332: BEGIN
1333: l_path_name := g_path||'get_default_account';

Line 1379: FA_BOOK_CONTROLS bc

1375: --nvl(REVAL_RSV_GAIN_ACCOUNT_CCID,-1),
1376: -- nvl(REVAL_RSV_LOSS_ACCOUNT_CCID,-1),
1377: bc.accounting_flex_structure
1378: FROM FA_DISTRIBUTION_ACCOUNTS da,
1379: FA_BOOK_CONTROLS bc
1380: WHERE bc.book_type_code = X_book_type_code
1381: AND da.book_type_code = bc.book_type_code
1382: AND da.distribution_id = X_distribution_id;
1383:

Line 1422: FROM FA_BOOK_CONTROLS

1418: AND category_id = p_asset_category_id;
1419:
1420: CURSOR c_get_intercompany is
1421: SELECT AP_INTERCOMPANY_ACCT,AR_INTERCOMPANY_ACCT
1422: FROM FA_BOOK_CONTROLS
1423: WHERE book_type_code = X_book_TYPE_Code;
1424:
1425: CURSOR get_accounts_from_FA is
1426: SELECT deprn_reserve_acct, asset_cost_acct

Line 1436: FROM FA_BOOK_CONTROLS

1432: WHERE asset_id = X_asset_id);
1433:
1434: CURSOR c_get_nbv_accounts is
1435: SELECT nbv_retired_gain_acct,nbv_retired_loss_acct
1436: FROM FA_BOOK_CONTROLS
1437: WHERE book_type_code = X_book_type_code;
1438:
1439: l_cost_ccid number ;
1440: l_clearing_ccid number ;

Line 1543: /* get the deault ccid from fa book controls */

1539: Account_ccid := -1;
1540: RETURN FALSE;
1541: END IF;
1542: --log('+ get ccid call get_distribution_ccid'||to_char(l_distribution_ccid));
1543: /* get the deault ccid from fa book controls */
1544: IF get_default_account ( X_book_type_code,
1545: l_default_ccid)THEN
1546:
1547: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,

Line 1962: /* get the deault ccid from fa book controls */

1958: Account_CCID => l_return_ccid) THEN
1959: Return False;
1960: END IF;
1961:
1962: /* get the deault ccid from fa book controls */
1963: IF get_default_account ( X_book_type_code,
1964: l_default_ccid)THEN
1965:
1966: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,