APPS.IGI_IAC_COMMON_UTILS dependencies on FA_BOOK_CONTROLS

Line 44: fa_book_controls bc

40: p_prd_rec.period_end_date, p_prd_rec.period_counter , p_prd_rec.fiscal_year
41: FROM fa_fiscal_year fy ,
42: fa_calendar_types ct ,
43: fa_calendar_periods cp,
44: fa_book_controls bc
45: WHERE ct.fiscal_year_name = fy.fiscal_year_name
46: AND bc.book_type_code = P_book_type_code
47: AND ct.calendar_type = bc.deprn_Calendar
48: AND fy.fiscal_year = decode( mod ( P_period_counter , ct.number_per_fiscal_year ) , 0 ,

Line 96: fa_book_controls bc

92: p_prd_rec.period_end_date, p_prd_rec.period_counter , p_prd_rec.fiscal_year
93: FROM fa_fiscal_year fy ,
94: fa_calendar_types ct ,
95: fa_calendar_periods cp ,
96: fa_book_controls bc
97: WHERE ct.fiscal_year_name = fy.fiscal_year_name
98: AND bc.book_type_code = P_book_type_code
99: AND ct.calendar_type = bc.deprn_Calendar
100: AND P_date between cp.start_date and cp.end_Date

Line 144: fa_book_controls bc

140: p_prd_rec.period_end_date, p_prd_rec.period_counter , p_prd_rec.fiscal_year
141: FROM fa_fiscal_year fy ,
142: fa_calendar_types ct ,
143: fa_calendar_periods cp ,
144: fa_book_controls bc
145: WHERE ct.fiscal_year_name = fy.fiscal_year_name
146: AND bc.book_type_code = P_book_type_code
147: AND ct.calendar_type = bc.deprn_Calendar
148: AND cp.calendar_type = ct.calendar_type

Line 679: FROM fa_Calendar_types ct , fa_book_controls bc

675: END IF;
676:
677: SELECT ct.calendar_type , ct.fiscal_year_name
678: INTO l_calendar , l_fiscal_year_name
679: FROM fa_Calendar_types ct , fa_book_controls bc
680: WHERE ct.calendar_type = bc.deprn_calendar
681: AND bc.book_type_Code = P_book_type_Code ;
682:
683: SELECT fy.start_Date

Line 808: fa_book_controls bc

804: l_prd_rec.period_end_date, l_prd_rec.period_counter , l_prd_rec.fiscal_year
805: FROM fa_fiscal_year fy ,
806: fa_calendar_types ct ,
807: fa_calendar_periods cp ,
808: fa_book_controls bc
809: WHERE ct.fiscal_year_name = fy.fiscal_year_name
810: AND bc.book_type_code = X_book_type_code
811: AND ct.calendar_type = bc.deprn_Calendar
812: AND l_dpis between cp.start_date and cp.end_Date

Line 907: from fa_book_controls

903: l_path_name VARCHAR2(150) ;
904:
905: Cursor dep_cal is
906: select deprn_calendar
907: from fa_book_controls
908: where book_type_code = X_book_type_code;
909:
910: Cursor start_end_dat(cp_dep_cal varchar2) is
911: select start_date , end_date

Line 978: fa_book_controls bc

974: RETURN BOOLEAN IS
975: CURSOR IAC_book IS
976: SELECT 'X'
977: FROM igi_iac_book_Controls ibc ,
978: fa_book_controls bc
979: WHERE bc.book_type_code = ibc.book_type_code
980: AND bc.date_ineffective IS NULL
981: AND bc.book_type_code = X_book_type_code;
982:

Line 1148: FROM fa_book_controls bc

1144: )
1145: RETURN BOOLEAN IS
1146: Cursor get_gl_info(p_book_type_code Varchar2) is
1147: SELECT bc.accounting_flex_structure, bc.set_of_books_id
1148: FROM fa_book_controls bc
1149: WHERE bc.book_type_code = p_book_type_code
1150: AND bc.date_ineffective IS NULL ;
1151: Cursor get_curr (p_set_of_books_id Number) is
1152: SELECT currency_code

Line 1299: FROM fa_book_controls

1295: Default_Account IN OUT NOCOPY NUMBER )
1296: RETURN BOOLEAN IS
1297: Cursor get_default (p_book_type_code Varchar2) IS
1298: SELECT flexbuilder_defaults_ccid
1299: FROM fa_book_controls
1300: WHERE book_type_code = p_book_type_code;
1301: l_path_name VARCHAR2(150);
1302: BEGIN
1303: l_path_name := g_path||'get_default_account';

Line 1349: FA_BOOK_CONTROLS bc

1345: --nvl(REVAL_RSV_GAIN_ACCOUNT_CCID,-1),
1346: -- nvl(REVAL_RSV_LOSS_ACCOUNT_CCID,-1),
1347: bc.accounting_flex_structure
1348: FROM FA_DISTRIBUTION_ACCOUNTS da,
1349: FA_BOOK_CONTROLS bc
1350: WHERE bc.book_type_code = X_book_type_code
1351: AND da.book_type_code = bc.book_type_code
1352: AND da.distribution_id = X_distribution_id;
1353:

Line 1392: FROM FA_BOOK_CONTROLS

1388: AND category_id = p_asset_category_id;
1389:
1390: CURSOR c_get_intercompany is
1391: SELECT AP_INTERCOMPANY_ACCT,AR_INTERCOMPANY_ACCT
1392: FROM FA_BOOK_CONTROLS
1393: WHERE book_type_code = X_book_TYPE_Code;
1394:
1395: CURSOR get_accounts_from_FA is
1396: SELECT deprn_reserve_acct, asset_cost_acct

Line 1406: FROM FA_BOOK_CONTROLS

1402: WHERE asset_id = X_asset_id);
1403:
1404: CURSOR c_get_nbv_accounts is
1405: SELECT nbv_retired_gain_acct,nbv_retired_loss_acct
1406: FROM FA_BOOK_CONTROLS
1407: WHERE book_type_code = X_book_type_code;
1408:
1409: l_cost_ccid number ;
1410: l_clearing_ccid number ;

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

1509: Account_ccid := -1;
1510: RETURN FALSE;
1511: END IF;
1512: --log('+ get ccid call get_distribution_ccid'||to_char(l_distribution_ccid));
1513: /* get the deault ccid from fa book controls */
1514: IF get_default_account ( X_book_type_code,
1515: l_default_ccid)THEN
1516:
1517: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,

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

1928: Account_CCID => l_return_ccid) THEN
1929: Return False;
1930: END IF;
1931:
1932: /* get the deault ccid from fa book controls */
1933: IF get_default_account ( X_book_type_code,
1934: l_default_ccid)THEN
1935:
1936: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,