APPS.CN_IMP_TRXAPI_PVT dependencies on CN_SALESREPS

Line 179: l_salesrep_id cn_salesreps.salesrep_id%TYPE;

175:
176: l_api_name CONSTANT VARCHAR2(30) := 'Trxapi_Import';
177:
178: l_trxapi_imp c_trxapi_imp_csr%ROWTYPE;
179: l_salesrep_id cn_salesreps.salesrep_id%TYPE;
180: l_rev_class_id cn_revenue_classes.revenue_class_id%TYPE;
181: l_role_id cn_roles.role_id%TYPE;
182: l_period_id cn_acc_period_statuses_v.period_id%TYPE;
183: l_rollup_period_id cn_acc_period_statuses_v.period_id%TYPE;

Line 282: FROM cn_salesreps

278: -- Get salesrep_id
279: BEGIN
280: SELECT salesrep_id
281: INTO l_salesrep_id
282: FROM cn_salesreps
283: WHERE employee_number = l_trxapi_imp.employee_number and org_id = p_org_id;
284: EXCEPTION
285: WHEN no_data_found THEN
286: l_failed_row := l_failed_row + 1;