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: BEGIN
788:
789: x_return_status := fnd_api.g_ret_sts_success;
790:

Line 807: FROM csi_txn_sub_types

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

Line 1771: FROM csi_txn_sub_types

1767: l_txn_type_id number;
1768:
1769: CURSOR sub_type_cur(p_txn_type_id IN number) IS
1770: SELECT 'X'
1771: FROM csi_txn_sub_types
1772: WHERE sub_type_id = p_sub_type_id
1773: AND transaction_type_id = nvl(p_txn_type_id, transaction_type_id);
1774:
1775: BEGIN