APPS.IGI_IAC_COMMON_UTILS dependencies on IGI_IAC_TRANSACTION_HEADERS

Line 532: FROM igi_iac_transaction_headers it

528: l_prev_prd_counter := l_curr_prd_Counter - 1;
529:
530: SELECT count(*)
531: INTO l_tot_records
532: FROM igi_iac_transaction_headers it
533: WHERE it.book_type_Code = P_book_type_code
534: AND it.asset_id = P_asset_id
535: AND it.transaction_type_Code = 'REVALUATION'
536: AND it.period_counter = l_prev_prd_counter

Line 1030: FROM igi_iac_transaction_headers

1026: transaction_type_code,
1027: transaction_header_id,
1028: nvl(mass_reference_id,0),
1029: adjustment_status
1030: FROM igi_iac_transaction_headers
1031: WHERE asset_id = x_asset_id
1032: AND book_type_code = x_book_type_code
1033: AND adjustment_id_out is null;
1034:

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

1031: WHERE asset_id = x_asset_id
1032: AND book_type_code = x_book_type_code
1033: AND adjustment_id_out is null;
1034:
1035: CURSOR get_prev_adj(c_adjustment_id igi_iac_transaction_headers.adjustment_id%TYPE) IS
1036: SELECT adjustment_id,
1037: transaction_type_code,
1038: transaction_header_id,
1039: nvl(mass_reference_id,0),

Line 1041: FROM igi_iac_transaction_headers

1037: transaction_type_code,
1038: transaction_header_id,
1039: nvl(mass_reference_id,0),
1040: adjustment_status
1041: FROM igi_iac_transaction_headers
1042: WHERE asset_id = x_asset_id
1043: AND book_type_code = x_book_type_code
1044: AND adjustment_id_out = c_adjustment_id;
1045:

Line 1048: FROM igi_iac_transaction_headers

1044: AND adjustment_id_out = c_adjustment_id;
1045:
1046: CURSOR get_adj_Trans_Type IS
1047: SELECT max(adjustment_id)
1048: FROM igi_iac_transaction_headers
1049: WHERE asset_id = x_asset_id
1050: AND book_type_code = x_book_type_code
1051: AND transaction_type_code = X_TRANSACTION_TYPE_CODE;
1052:

Line 1055: FROM igi_iac_transaction_headers

1051: AND transaction_type_code = X_TRANSACTION_TYPE_CODE;
1052:
1053: CURSOR get_trans (p_adjustment_id Number) IS
1054: SELECT transaction_header_id, nvl(mass_reference_id,0), adjustment_status
1055: FROM igi_iac_transaction_headers
1056: WHERE asset_id = x_asset_id
1057: AND book_type_code = x_book_type_code
1058: AND adjustment_id = p_adjustment_id;
1059:

Line 1061: l_adjustment_id igi_iac_transaction_headers.adjustment_id%TYPE;

1057: AND book_type_code = x_book_type_code
1058: AND adjustment_id = p_adjustment_id;
1059:
1060: l_non_preview_trans BOOLEAN;
1061: l_adjustment_id igi_iac_transaction_headers.adjustment_id%TYPE;
1062: l_path_name VARCHAR2(150);
1063: BEGIN
1064: l_non_preview_trans := FALSE;
1065: l_path_name := g_path||'get_latest_transaction';

Line 1368: FROM igi_iac_transaction_headers

1364: WHERE asset_id = X_asset_id;
1365:
1366: Cursor get_iac_category_id is
1367: SELECT category_id
1368: FROM igi_iac_transaction_headers
1369: Where asset_id = X_asset_id
1370: and book_type_code = X_book_type_code
1371: and adjustment_id_out is null;
1372: