APPS.OKL_BPD_ADVANCED_BILLING_PVT dependencies on RA_SALESREPS

Line 758: CURSOR sales_rep_csr(p_salesrep_id IN ra_salesreps.salesrep_id%TYPE) IS

754: SELECT decode(p_flg,'S','S','E','E','R','R','S')
755: FROM DUAL;
756:
757: --stmathew - Bug 4372869/4222231..start
758: CURSOR sales_rep_csr(p_salesrep_id IN ra_salesreps.salesrep_id%TYPE) IS
759: SELECT SALESREP_ID, NAME
760: FROM ra_salesreps
761: WHERE SALESREP_ID = p_salesrep_id;
762:

Line 760: FROM ra_salesreps

756:
757: --stmathew - Bug 4372869/4222231..start
758: CURSOR sales_rep_csr(p_salesrep_id IN ra_salesreps.salesrep_id%TYPE) IS
759: SELECT SALESREP_ID, NAME
760: FROM ra_salesreps
761: WHERE SALESREP_ID = p_salesrep_id;
762:
763: --cursor to fetch the sales rep for the contract.
764: CURSOR get_sales_rep(p_contract_number okc_k_headers_b.contract_number%TYPE) IS

Line 771: l_salesrep_id ra_salesreps.SALESREP_ID%TYPE;

767: WHERE contact.dnz_chr_id = hdr.id
768: AND hdr.contract_number = p_contract_number
769: AND contact.cro_code = 'SALESPERSON';
770:
771: l_salesrep_id ra_salesreps.SALESREP_ID%TYPE;
772: l_salesrep_name ra_salesreps.NAME%TYPE;
773: l_sales_person okc_contacts_v.object1_id1%TYPE;
774: --stmathew - Bug 4372869/4222231..end
775: --start:| 06-Apr-2007 cklee -- Fixed kle_id, asset_number issues |

Line 772: l_salesrep_name ra_salesreps.NAME%TYPE;

768: AND hdr.contract_number = p_contract_number
769: AND contact.cro_code = 'SALESPERSON';
770:
771: l_salesrep_id ra_salesreps.SALESREP_ID%TYPE;
772: l_salesrep_name ra_salesreps.NAME%TYPE;
773: l_sales_person okc_contacts_v.object1_id1%TYPE;
774: --stmathew - Bug 4372869/4222231..end
775: --start:| 06-Apr-2007 cklee -- Fixed kle_id, asset_number issues |
776: l_is_top_line number;

Line 2220: FROM ra_salesreps

2216: l_rev_rec_basis okl_strm_type_b.accrual_yn%type;
2217:
2218: CURSOR sales_rep_csr IS
2219: SELECT SALESREP_ID, SALESREP_NUMBER
2220: FROM ra_salesreps
2221: WHERE NAME = 'No Sales Credit';
2222:
2223:
2224: CURSOR sales_type_credit_csr IS

Line 2229: l_salesrep_id ra_salesreps.SALESREP_ID%TYPE;

2225: SELECT sales_credit_type_id
2226: FROM so_sales_credit_types
2227: WHERE name = 'Quota Sales Credit';
2228:
2229: l_salesrep_id ra_salesreps.SALESREP_ID%TYPE;
2230: l_salesrep_number ra_salesreps.SALESREP_NUMBER%TYPE;
2231: l_sales_type_credit so_sales_credit_types.sales_credit_type_id%TYPE;
2232: */
2233: --end: | 02-APR-07 cklee R12 Billing enhancement project |

Line 2230: l_salesrep_number ra_salesreps.SALESREP_NUMBER%TYPE;

2226: FROM so_sales_credit_types
2227: WHERE name = 'Quota Sales Credit';
2228:
2229: l_salesrep_id ra_salesreps.SALESREP_ID%TYPE;
2230: l_salesrep_number ra_salesreps.SALESREP_NUMBER%TYPE;
2231: l_sales_type_credit so_sales_credit_types.sales_credit_type_id%TYPE;
2232: */
2233: --end: | 02-APR-07 cklee R12 Billing enhancement project |
2234: