110: --
111: CURSOR header_cur(l_commission_header_id NUMBER) IS
112: SELECT a.*,b.employee_number
113: FROM cn_commission_headers a,
114: cn_salesreps b
115: WHERE a.direct_salesrep_id = b.salesrep_id
116: AND commission_header_id = l_commission_header_id;
117:
118: -- Added for bug 7524578
1139: x_split_percent)/100);
1140: --
1141: SELECT employee_number
1142: INTO l_salesrep_number
1143: FROM cn_salesreps
1144: WHERE salesrep_id = x_salesrep_id;
1145: --
1146: SELECT cn_comm_lines_api_s.NEXTVAL
1147: INTO l_ins_comm_lines_api_id
1290: END IF; */
1291: --
1292: SELECT employee_number
1293: INTO l_salesrep_number
1294: FROM cn_salesreps
1295: WHERE salesrep_id = x_to_salesrep_id;
1296: --
1297: SELECT cn_comm_lines_api_s.NEXTVAL
1298: INTO l_ins_comm_lines_api_id