APPS.IGI_IGIIAOPE_XMLP_PKG dependencies on IGI_IAC_DET_BALANCES

Line 656: IGI_IAC_DET_BALANCES DD,

652: 'IAC',
653: 2
654: FROM
655: FA_DISTRIBUTION_HISTORY DH,
656: IGI_IAC_DET_BALANCES DD,
657: FA_ASSET_HISTORY AH,
658: FA_CATEGORY_BOOKS CB,
659: IGI_IAC_CATEGORY_BOOKS ICB,
660: FA_BOOKS BK,

Line 778: IGI_IAC_DET_BALANCES DD,

774: 'GENERAL FUND',2,
775: 'NET',4) )
776: FROM
777: FA_DISTRIBUTION_HISTORY DH,
778: IGI_IAC_DET_BALANCES DD,
779: FA_ASSET_HISTORY AH,
780: FA_CATEGORY_BOOKS CB,
781: IGI_IAC_CATEGORY_BOOKS ICB,
782: FA_BOOKS BK,

Line 855: igi_iac_det_balances db,

851: 'COST',1,
852: 'BACKLOG',2,
853: 'NET',3)
854: FROM
855: igi_iac_det_balances db,
856: fa_distribution_history dh,
857: fa_asset_history ah,
858: igi_iac_category_books icb
859: WHERE

Line 869: FROM igi_iac_det_balances idb

865: icb.book_type_code = p_book AND
866: icb.category_id = ah.category_id AND
867: db.distribution_id = dh.distribution_id AND
868: db.adjustment_id = (SELECT max(idb.adjustment_id)
869: FROM igi_iac_det_balances idb
870: WHERE idb.book_type_code = p_book AND
871: idb.asset_id = dh.asset_id AND
872: idb.distribution_id = db.distribution_id AND
873: idb.period_counter <= p_period_pc);

Line 1010: FROM igi_iac_det_balances curr_adj,

1006: (curr_adj.reval_reserve_backlog - prev_adj.reval_reserve_backlog) reval_reserve_backlog,
1007: (curr_adj.general_fund_acc - prev_adj.general_fund_acc) general_fund,
1008: (curr_adj.Operating_acct_cost - prev_adj.Operating_acct_cost) operating_acct_cost,
1009: (curr_adj.Operating_acct_backlog - prev_adj.Operating_acct_backlog) operating_acct_backlog
1010: FROM igi_iac_det_balances curr_adj,
1011: igi_iac_det_balances prev_adj
1012: WHERE curr_adj.book_type_code = cp_book
1013: AND curr_adj.asset_id = cp_asset_id
1014: AND prev_adj.book_type_code = cp_book

Line 1011: igi_iac_det_balances prev_adj

1007: (curr_adj.general_fund_acc - prev_adj.general_fund_acc) general_fund,
1008: (curr_adj.Operating_acct_cost - prev_adj.Operating_acct_cost) operating_acct_cost,
1009: (curr_adj.Operating_acct_backlog - prev_adj.Operating_acct_backlog) operating_acct_backlog
1010: FROM igi_iac_det_balances curr_adj,
1011: igi_iac_det_balances prev_adj
1012: WHERE curr_adj.book_type_code = cp_book
1013: AND curr_adj.asset_id = cp_asset_id
1014: AND prev_adj.book_type_code = cp_book
1015: AND prev_adj.asset_id = cp_asset_id

Line 1033: FROM igi_iac_det_balances adj

1029: adj.reval_reserve_backlog reval_reserve_backlog,
1030: adj.general_fund_acc general_fund,
1031: adj.operating_acct_cost operating_acct_cost,
1032: adj.operating_acct_backlog operating_acct_backlog
1033: FROM igi_iac_det_balances adj
1034: WHERE book_type_code = cp_book
1035: AND asset_id = cp_asset_id
1036: AND adjustment_id = cp_curr_adj_id
1037: AND NOT EXISTS (SELECT 'X'

Line 1038: FROM igi_iac_det_balances sub_adj

1034: WHERE book_type_code = cp_book
1035: AND asset_id = cp_asset_id
1036: AND adjustment_id = cp_curr_adj_id
1037: AND NOT EXISTS (SELECT 'X'
1038: FROM igi_iac_det_balances sub_adj
1039: WHERE sub_adj.book_type_code = cp_book
1040: AND sub_adj.asset_id = cp_asset_id
1041: AND sub_adj.adjustment_id = cp_prev_adj_id
1042: AND sub_adj.distribution_id = adj.distribution_id);

Line 1057: FROM igi_iac_det_balances adj

1053: (adj.reval_reserve_backlog * -1) reval_reserve_backlog,
1054: (adj.general_fund_acc * -1) general_fund,
1055: (adj.operating_acct_cost * -1) operating_acct_cost,
1056: (adj.operating_acct_backlog * -1) operating_acct_backlog
1057: FROM igi_iac_det_balances adj
1058: WHERE book_type_code = cp_book
1059: AND asset_id = cp_asset_id
1060: AND adjustment_id = cp_prev_adj_id
1061: AND NOT EXISTS (SELECT 'X'

Line 1062: FROM igi_iac_det_balances sub_adj

1058: WHERE book_type_code = cp_book
1059: AND asset_id = cp_asset_id
1060: AND adjustment_id = cp_prev_adj_id
1061: AND NOT EXISTS (SELECT 'X'
1062: FROM igi_iac_det_balances sub_adj
1063: WHERE sub_adj.book_type_code = cp_book
1064: AND sub_adj.asset_id = cp_asset_id
1065: AND sub_adj.adjustment_id = cp_curr_adj_id
1066: AND sub_adj.distribution_id = adj.distribution_id);