APPS.IGI_IGIIARSV_XMLP_PKG dependencies on IGI_IAC_DET_BALANCES

Line 670: IGI_IAC_DET_BALANCES DD,

666: 'IAC',
667: 2
668: FROM
669: FA_DISTRIBUTION_HISTORY DH,
670: IGI_IAC_DET_BALANCES DD,
671: FA_ASSET_HISTORY AH,
672: FA_CATEGORY_BOOKS CB,
673: IGI_IAC_CATEGORY_BOOKS ICB,
674: FA_BOOKS BK,

Line 792: IGI_IAC_DET_BALANCES DD,

788: 'GENERAL FUND',2,
789: 'NET',4) )
790: FROM
791: FA_DISTRIBUTION_HISTORY DH,
792: IGI_IAC_DET_BALANCES DD,
793: FA_ASSET_HISTORY AH,
794: FA_CATEGORY_BOOKS CB,
795: IGI_IAC_CATEGORY_BOOKS ICB,
796: FA_BOOKS BK,

Line 869: igi_iac_det_balances db,

865: 'COST',1,
866: 'BACKLOG',2,
867: 'NET',3)
868: FROM
869: igi_iac_det_balances db,
870: fa_distribution_history dh,
871: fa_asset_history ah,
872: igi_iac_category_books icb
873: WHERE

Line 883: FROM igi_iac_det_balances idb

879: icb.book_type_code = p_book AND
880: icb.category_id = ah.category_id AND
881: db.distribution_id = dh.distribution_id AND
882: db.adjustment_id = (SELECT max(idb.adjustment_id)
883: FROM igi_iac_det_balances idb
884: WHERE idb.book_type_code = p_book AND
885: idb.asset_id = dh.asset_id AND
886: idb.distribution_id = db.distribution_id AND
887: idb.period_counter <= p_period_pc);

Line 1024: FROM igi_iac_det_balances curr_adj,

1020: (curr_adj.reval_reserve_backlog - prev_adj.reval_reserve_backlog) reval_reserve_backlog,
1021: (curr_adj.general_fund_acc - prev_adj.general_fund_acc) general_fund,
1022: (curr_adj.Operating_acct_cost - prev_adj.Operating_acct_cost) operating_acct_cost,
1023: (curr_adj.Operating_acct_backlog - prev_adj.Operating_acct_backlog) operating_acct_backlog
1024: FROM igi_iac_det_balances curr_adj,
1025: igi_iac_det_balances prev_adj
1026: WHERE curr_adj.book_type_code = cp_book
1027: AND curr_adj.asset_id = cp_asset_id
1028: AND prev_adj.book_type_code = cp_book

Line 1025: igi_iac_det_balances prev_adj

1021: (curr_adj.general_fund_acc - prev_adj.general_fund_acc) general_fund,
1022: (curr_adj.Operating_acct_cost - prev_adj.Operating_acct_cost) operating_acct_cost,
1023: (curr_adj.Operating_acct_backlog - prev_adj.Operating_acct_backlog) operating_acct_backlog
1024: FROM igi_iac_det_balances curr_adj,
1025: igi_iac_det_balances prev_adj
1026: WHERE curr_adj.book_type_code = cp_book
1027: AND curr_adj.asset_id = cp_asset_id
1028: AND prev_adj.book_type_code = cp_book
1029: AND prev_adj.asset_id = cp_asset_id

Line 1047: FROM igi_iac_det_balances adj

1043: adj.reval_reserve_backlog reval_reserve_backlog,
1044: adj.general_fund_acc general_fund,
1045: adj.operating_acct_cost operating_acct_cost,
1046: adj.operating_acct_backlog operating_acct_backlog
1047: FROM igi_iac_det_balances adj
1048: WHERE book_type_code = cp_book
1049: AND asset_id = cp_asset_id
1050: AND adjustment_id = cp_curr_adj_id
1051: AND NOT EXISTS (SELECT 'X'

Line 1052: FROM igi_iac_det_balances sub_adj

1048: WHERE book_type_code = cp_book
1049: AND asset_id = cp_asset_id
1050: AND adjustment_id = cp_curr_adj_id
1051: AND NOT EXISTS (SELECT 'X'
1052: FROM igi_iac_det_balances sub_adj
1053: WHERE sub_adj.book_type_code = cp_book
1054: AND sub_adj.asset_id = cp_asset_id
1055: AND sub_adj.adjustment_id = cp_prev_adj_id
1056: AND sub_adj.distribution_id = adj.distribution_id);

Line 1071: FROM igi_iac_det_balances adj

1067: (adj.reval_reserve_backlog * -1) reval_reserve_backlog,
1068: (adj.general_fund_acc * -1) general_fund,
1069: (adj.operating_acct_cost * -1) operating_acct_cost,
1070: (adj.operating_acct_backlog * -1) operating_acct_backlog
1071: FROM igi_iac_det_balances adj
1072: WHERE book_type_code = cp_book
1073: AND asset_id = cp_asset_id
1074: AND adjustment_id = cp_prev_adj_id
1075: AND NOT EXISTS (SELECT 'X'

Line 1076: FROM igi_iac_det_balances sub_adj

1072: WHERE book_type_code = cp_book
1073: AND asset_id = cp_asset_id
1074: AND adjustment_id = cp_prev_adj_id
1075: AND NOT EXISTS (SELECT 'X'
1076: FROM igi_iac_det_balances sub_adj
1077: WHERE sub_adj.book_type_code = cp_book
1078: AND sub_adj.asset_id = cp_asset_id
1079: AND sub_adj.adjustment_id = cp_curr_adj_id
1080: AND sub_adj.distribution_id = adj.distribution_id);