APPS.CSI_T_VLDN_ROUTINES_PVT dependencies on CSI_TXN_SUB_TYPES

Line 786: l_sub_type_rec csi_txn_sub_types%rowtype;

782: x_return_status OUT NOCOPY VARCHAR2)
783: IS
784: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;
785: l_owner_count number;
786: l_sub_type_rec csi_txn_sub_types%rowtype;
787: l_serial_control_code mtl_system_items.serial_number_control_code%TYPE; -- Added for Bug 13896396
788: BEGIN
789:
790: x_return_status := fnd_api.g_ret_sts_success;

Line 808: FROM csi_txn_sub_types

804: SELECT src_change_owner,
805: non_src_change_owner
806: INTO l_sub_type_rec.src_change_owner,
807: l_sub_type_rec.non_src_change_owner
808: FROM csi_txn_sub_types
809: WHERE sub_type_id = p_txn_line_dtl_tbl(l_td_ind).sub_type_id
810: AND transaction_type_id = p_txn_line_rec.source_transaction_type_id;
811:
812: EXCEPTION

Line 1798: FROM csi_txn_sub_types

1794: l_txn_type_id number;
1795:
1796: CURSOR sub_type_cur(p_txn_type_id IN number) IS
1797: SELECT 'X'
1798: FROM csi_txn_sub_types
1799: WHERE sub_type_id = p_sub_type_id
1800: AND transaction_type_id = nvl(p_txn_type_id, transaction_type_id);
1801:
1802: BEGIN