APPS.CSI_CZ_INT dependencies on CSI_T_TRANSACTION_LINES

Line 56: FROM csi_t_transaction_lines ctl,

52: */
53:
54: CURSOR proposed_cur(p_inst_hdr_id in number) IS
55: SELECT ctd.config_inst_rev_num
56: FROM csi_t_transaction_lines ctl,
57: csi_t_txn_line_details ctd
58: WHERE ctd.config_inst_hdr_id = p_inst_hdr_id
59: AND ctl.transaction_line_id = ctd.transaction_line_id
60: AND ctl.source_transaction_status = 'PROPOSED'

Line 583: FROM csi_t_transaction_lines ctl,

579: ctld.CONFIG_INST_HDR_ID,
580: ctld.CONFIG_INST_REV_NUM,
581: ctld.CONFIG_INST_ITEM_ID,
582: ctld.instance_id
583: FROM csi_t_transaction_lines ctl,
584: csi_t_txn_line_details ctld
585: WHERE ctl.transaction_line_id = ctld.transaction_line_id
586: AND CONFIG_INST_HDR_ID = p_config_inst_hdr_id
587: AND CONFIG_INST_REV_NUM = p_config_inst_rev_num;

Line 1477: FROM csi_t_transaction_lines

1473: CURSOR td_cur(p_sess_hdr_id IN number, p_sess_rev_num IN number) IS
1474: SELECT config_session_hdr_id,
1475: config_session_rev_num,
1476: config_session_item_id
1477: FROM csi_t_transaction_lines
1478: WHERE config_session_hdr_id = p_sess_hdr_id
1479: -- Added the and condition for Bug 3711457
1480: AND config_session_rev_num = p_sess_rev_num
1481: ORDER BY config_session_item_id;