APPS.IGI_IGIIABLS_XMLP_PKG dependencies on IGI_IAC_DET_BALANCES

Line 675: IGI_IAC_DET_BALANCES DD,

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

Line 797: IGI_IAC_DET_BALANCES DD,

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

Line 874: igi_iac_det_balances db,

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

Line 888: FROM igi_iac_det_balances idb

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

Line 1029: FROM igi_iac_det_balances curr_adj,

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

Line 1030: igi_iac_det_balances prev_adj

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

Line 1052: FROM igi_iac_det_balances adj

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

Line 1057: FROM igi_iac_det_balances sub_adj

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

Line 1076: FROM igi_iac_det_balances adj

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

Line 1081: FROM igi_iac_det_balances sub_adj

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