APPS.IGI_IAC_COMMON_UTILS dependencies on IGI_IAC_TRANSACTION_HEADERS

Line 562: FROM igi_iac_transaction_headers it

558: l_prev_prd_counter := l_curr_prd_Counter - 1;
559:
560: SELECT count(*)
561: INTO l_tot_records
562: FROM igi_iac_transaction_headers it
563: WHERE it.book_type_Code = P_book_type_code
564: AND it.asset_id = P_asset_id
565: AND it.transaction_type_Code = 'REVALUATION'
566: AND it.period_counter = l_prev_prd_counter

Line 1060: FROM igi_iac_transaction_headers

1056: transaction_type_code,
1057: transaction_header_id,
1058: nvl(mass_reference_id,0),
1059: adjustment_status
1060: FROM igi_iac_transaction_headers
1061: WHERE asset_id = x_asset_id
1062: AND book_type_code = x_book_type_code
1063: AND adjustment_id_out is null;
1064:

Line 1065: CURSOR get_prev_adj(c_adjustment_id igi_iac_transaction_headers.adjustment_id%TYPE) IS

1061: WHERE asset_id = x_asset_id
1062: AND book_type_code = x_book_type_code
1063: AND adjustment_id_out is null;
1064:
1065: CURSOR get_prev_adj(c_adjustment_id igi_iac_transaction_headers.adjustment_id%TYPE) IS
1066: SELECT adjustment_id,
1067: transaction_type_code,
1068: transaction_header_id,
1069: nvl(mass_reference_id,0),

Line 1071: FROM igi_iac_transaction_headers

1067: transaction_type_code,
1068: transaction_header_id,
1069: nvl(mass_reference_id,0),
1070: adjustment_status
1071: FROM igi_iac_transaction_headers
1072: WHERE asset_id = x_asset_id
1073: AND book_type_code = x_book_type_code
1074: AND adjustment_id_out = c_adjustment_id;
1075:

Line 1078: FROM igi_iac_transaction_headers

1074: AND adjustment_id_out = c_adjustment_id;
1075:
1076: CURSOR get_adj_Trans_Type IS
1077: SELECT max(adjustment_id)
1078: FROM igi_iac_transaction_headers
1079: WHERE asset_id = x_asset_id
1080: AND book_type_code = x_book_type_code
1081: AND transaction_type_code = X_TRANSACTION_TYPE_CODE;
1082:

Line 1085: FROM igi_iac_transaction_headers

1081: AND transaction_type_code = X_TRANSACTION_TYPE_CODE;
1082:
1083: CURSOR get_trans (p_adjustment_id Number) IS
1084: SELECT transaction_header_id, nvl(mass_reference_id,0), adjustment_status
1085: FROM igi_iac_transaction_headers
1086: WHERE asset_id = x_asset_id
1087: AND book_type_code = x_book_type_code
1088: AND adjustment_id = p_adjustment_id;
1089:

Line 1091: l_adjustment_id igi_iac_transaction_headers.adjustment_id%TYPE;

1087: AND book_type_code = x_book_type_code
1088: AND adjustment_id = p_adjustment_id;
1089:
1090: l_non_preview_trans BOOLEAN;
1091: l_adjustment_id igi_iac_transaction_headers.adjustment_id%TYPE;
1092: l_path_name VARCHAR2(150);
1093: BEGIN
1094: l_non_preview_trans := FALSE;
1095: l_path_name := g_path||'get_latest_transaction';

Line 1398: FROM igi_iac_transaction_headers

1394: WHERE asset_id = X_asset_id;
1395:
1396: Cursor get_iac_category_id is
1397: SELECT category_id
1398: FROM igi_iac_transaction_headers
1399: Where asset_id = X_asset_id
1400: and book_type_code = X_book_type_code
1401: and adjustment_id_out is null;
1402: