APPS.IGI_IGIIABLD_XMLP_PKG dependencies on IGI_IAC_DET_BALANCES

Line 673: IGI_IAC_DET_BALANCES DD,

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

Line 795: IGI_IAC_DET_BALANCES DD,

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

Line 872: igi_iac_det_balances db,

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

Line 886: FROM igi_iac_det_balances idb

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

Line 1027: FROM igi_iac_det_balances curr_adj,

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

Line 1028: igi_iac_det_balances prev_adj

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

Line 1050: FROM igi_iac_det_balances adj

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

Line 1055: FROM igi_iac_det_balances sub_adj

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

Line 1074: FROM igi_iac_det_balances adj

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

Line 1079: FROM igi_iac_det_balances sub_adj

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