APPS.IGI_IGIIACSD_XMLP_PKG dependencies on IGI_IAC_DET_BALANCES

Line 654: IGI_IAC_DET_BALANCES DD,

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

Line 776: IGI_IAC_DET_BALANCES DD,

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

Line 853: igi_iac_det_balances db,

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

Line 867: FROM igi_iac_det_balances idb

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

Line 1008: FROM igi_iac_det_balances curr_adj,

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

Line 1009: igi_iac_det_balances prev_adj

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

Line 1031: FROM igi_iac_det_balances adj

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

Line 1036: FROM igi_iac_det_balances sub_adj

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

Line 1055: FROM igi_iac_det_balances adj

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

Line 1060: FROM igi_iac_det_balances sub_adj

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