DBA Data[Home] [Help]

APPS.OKL_INVESTOR_BILLING_PVT dependencies on RA_SALESREPS

Line 235: FROM RA_SALESREPS

231:
232: -- BEGIN bvaghela 032305 bug 4256274 --
233: CURSOR sales_rep_csr IS
234: SELECT SALESREP_ID, SALESREP_NUMBER
235: FROM RA_SALESREPS
236: WHERE NAME = 'No Sales Credit';
237:
238:
239: CURSOR sales_type_credit_csr IS

Line 275: l_salesrep_id ra_salesreps.SALESREP_ID%TYPE;

271: -- Local Variables
272: ------------------------------------------------------------
273:
274: -- BEGIN bvaghela 032305 bug 4256274 --
275: l_salesrep_id ra_salesreps.SALESREP_ID%TYPE;
276: l_salesrep_number ra_salesreps.SALESREP_NUMBER%TYPE;
277: l_sales_type_credit so_sales_credit_types.sales_credit_type_id%TYPE;
278: l_user_id NUMBER := FND_global.user_id;
279: l_sysdate DATE := sysdate;

Line 276: l_salesrep_number ra_salesreps.SALESREP_NUMBER%TYPE;

272: ------------------------------------------------------------
273:
274: -- BEGIN bvaghela 032305 bug 4256274 --
275: l_salesrep_id ra_salesreps.SALESREP_ID%TYPE;
276: l_salesrep_number ra_salesreps.SALESREP_NUMBER%TYPE;
277: l_sales_type_credit so_sales_credit_types.sales_credit_type_id%TYPE;
278: l_user_id NUMBER := FND_global.user_id;
279: l_sysdate DATE := sysdate;
280: -- END bvaghela 032305 bug 4256274 --