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 283: FROM cn_salesreps

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