APPS.CSI_UTILITY_GRP dependencies on CSI_T_TXN_LINE_DETAILS

Line 177: csi_t_txn_line_details ctd

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
181: AND ctl.transaction_line_id = ctd.transaction_line_id;

Line 856: FROM csi_t_txn_line_details cil,

852: CURSOR dummy_csr(pc_batch_id IN NUMBER) IS
853: SELECT cil.active_end_date active_end_date
854: ,cil.installation_date installation_date
855: ,cil.txn_line_detail_id txn_line_detail_id
856: FROM csi_t_txn_line_details cil,
857: csi_mass_edit_entries_b cmee
858: WHERE cmee.entry_id = pc_batch_id
859: AND cmee.txn_line_id = cil.transaction_line_id
860: AND cil.instance_id IS NULL;

Line 1003: FROM csi_t_txn_line_details cil,

999:
1000: -- FTS on this cursor
1001: CURSOR inst_csr(pc_batch_id IN NUMBER) IS
1002: SELECT cil.instance_id instance_id
1003: FROM csi_t_txn_line_details cil,
1004: csi_mass_edit_entries_b cmee
1005: WHERE cmee.entry_id = pc_batch_id
1006: AND cmee.txn_line_id = cil.transaction_line_id
1007: AND cil.instance_id IS NOT NULL;

Line 1015: FROM csi_t_txn_line_details cil,

1011: CURSOR dummy_csr(pc_batch_id IN NUMBER) IS
1012: SELECT cil.active_end_date active_end_date
1013: ,cil.installation_date installation_date
1014: ,cil.txn_line_detail_id txn_line_detail_id
1015: FROM csi_t_txn_line_details cil,
1016: csi_mass_edit_entries_b cmee
1017: WHERE cmee.entry_id = pc_batch_id
1018: AND cmee.txn_line_id = cil.transaction_line_id
1019: AND cil.instance_id IS NULL;

Line 1712: FROM csi_t_txn_line_details

1708: BEGIN
1709: debug_con_log(' Check to see if any of the Txn Lines are a Non Source Type for Txn Line ID: '||r_processed_recs.transaction_line_id);
1710: SELECT count(*)
1711: INTO l_processed_recs
1712: FROM csi_t_txn_line_details
1713: WHERE transaction_line_id = r_processed_recs.transaction_line_id
1714: AND source_transaction_flag = 'N';
1715:
1716: IF l_processed_recs = 0 THEN