APPS.CN_ADJUSTMENTS_PKG dependencies on CN_SALESREPS

Line 114: cn_salesreps b

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

Line 1141: FROM cn_salesreps

1137: x_split_percent)/100);
1138: --
1139: SELECT employee_number
1140: INTO l_salesrep_number
1141: FROM cn_salesreps
1142: WHERE salesrep_id = x_salesrep_id;
1143: --
1144: SELECT cn_comm_lines_api_s.NEXTVAL
1145: INTO l_ins_comm_lines_api_id

Line 1292: FROM cn_salesreps

1288: END IF; */
1289: --
1290: SELECT employee_number
1291: INTO l_salesrep_number
1292: FROM cn_salesreps
1293: WHERE salesrep_id = x_to_salesrep_id;
1294: --
1295: SELECT cn_comm_lines_api_s.NEXTVAL
1296: INTO l_ins_comm_lines_api_id