APPS.IGI_IGIIARRD_XMLP_PKG dependencies on IGI_IAC_DET_BALANCES

Line 669: IGI_IAC_DET_BALANCES DD,

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

Line 791: IGI_IAC_DET_BALANCES DD,

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

Line 868: igi_iac_det_balances db,

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

Line 882: FROM igi_iac_det_balances idb

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

Line 1023: FROM igi_iac_det_balances curr_adj,

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

Line 1024: igi_iac_det_balances prev_adj

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

Line 1046: FROM igi_iac_det_balances adj

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

Line 1051: FROM igi_iac_det_balances sub_adj

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

Line 1070: FROM igi_iac_det_balances adj

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

Line 1075: FROM igi_iac_det_balances sub_adj

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