APPS.CSI_UTILITY_GRP dependencies on CSI_T_TRANSACTION_LINES

Line 176: FROM csi_t_transaction_lines ctl,

172: BEGIN
173:
174: SELECT config_valid_status
175: INTO x_config_valid_status
176: FROM csi_t_transaction_lines ctl,
177: csi_t_txn_line_details ctd
178: WHERE ctd.config_inst_hdr_id = p_instance_key.inst_hdr_id
179: AND ctd.config_inst_rev_num = p_instance_key.inst_rev_num
180: AND ctd.config_inst_item_id = p_instance_key.inst_item_id

Line 1602: FROM csi_t_transaction_lines

1598: WHERE status_code = p_status;
1599:
1600: CURSOR c_processed_recs (p_status IN VARCHAR2) IS
1601: SELECT transaction_line_id
1602: FROM csi_t_transaction_lines
1603: WHERE processing_status = p_status
1604: AND migrated_flag is NULL;
1605:
1606: CURSOR c_migrated_recs IS

Line 1609: FROM csi_t_transaction_lines

1605:
1606: CURSOR c_migrated_recs IS
1607: SELECT transaction_line_id,
1608: source_transaction_id
1609: FROM csi_t_transaction_lines
1610: WHERE migrated_flag = 'Y';
1611:
1612: BEGIN
1613:

Line 1773: debug_con_log(' Check to see if the Txn Line in Mass Update has any records in csi_t_transaction_lines: '||r_mu.txn_line_id);

1769:
1770: l_mass_update_recs := 0;
1771:
1772: BEGIN
1773: debug_con_log(' Check to see if the Txn Line in Mass Update has any records in csi_t_transaction_lines: '||r_mu.txn_line_id);
1774: SELECT 1
1775: INTO l_mass_update_recs
1776: FROM csi_t_transaction_lines
1777: WHERE transaction_line_id = r_mu.txn_line_id;

Line 1776: FROM csi_t_transaction_lines

1772: BEGIN
1773: debug_con_log(' Check to see if the Txn Line in Mass Update has any records in csi_t_transaction_lines: '||r_mu.txn_line_id);
1774: SELECT 1
1775: INTO l_mass_update_recs
1776: FROM csi_t_transaction_lines
1777: WHERE transaction_line_id = r_mu.txn_line_id;
1778:
1779: EXCEPTION
1780: WHEN no_data_found THEN