APPS.OKL_BPD_ADVANCED_BILLING_PVT dependencies on RA_SALESREPS

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

512: SELECT decode(p_flg,'S','S','E','E','R','R','S')
513: FROM DUAL;
514:
515: --stmathew - Bug 4372869/4222231..start
516: CURSOR sales_rep_csr(p_salesrep_id IN ra_salesreps.salesrep_id%TYPE) IS
517: SELECT SALESREP_ID, NAME
518: FROM ra_salesreps
519: WHERE SALESREP_ID = p_salesrep_id;
520:

Line 518: FROM ra_salesreps

514:
515: --stmathew - Bug 4372869/4222231..start
516: CURSOR sales_rep_csr(p_salesrep_id IN ra_salesreps.salesrep_id%TYPE) IS
517: SELECT SALESREP_ID, NAME
518: FROM ra_salesreps
519: WHERE SALESREP_ID = p_salesrep_id;
520:
521: --cursor to fetch the sales rep for the contract.
522: CURSOR get_sales_rep(p_contract_number okc_k_headers_b.contract_number%TYPE) IS

Line 529: l_salesrep_id ra_salesreps.SALESREP_ID%TYPE;

525: WHERE contact.dnz_chr_id = hdr.id
526: AND hdr.contract_number = p_contract_number
527: AND contact.cro_code = 'SALESPERSON';
528:
529: l_salesrep_id ra_salesreps.SALESREP_ID%TYPE;
530: l_salesrep_name ra_salesreps.NAME%TYPE;
531: l_sales_person okc_contacts_v.object1_id1%TYPE;
532: --stmathew - Bug 4372869/4222231..end
533: --start:| 06-Apr-2007 cklee -- Fixed kle_id, asset_number issues |

Line 530: l_salesrep_name ra_salesreps.NAME%TYPE;

526: AND hdr.contract_number = p_contract_number
527: AND contact.cro_code = 'SALESPERSON';
528:
529: l_salesrep_id ra_salesreps.SALESREP_ID%TYPE;
530: l_salesrep_name ra_salesreps.NAME%TYPE;
531: l_sales_person okc_contacts_v.object1_id1%TYPE;
532: --stmathew - Bug 4372869/4222231..end
533: --start:| 06-Apr-2007 cklee -- Fixed kle_id, asset_number issues |
534: l_is_top_line number;

Line 2012: FROM ra_salesreps

2008: l_rev_rec_basis okl_strm_type_b.accrual_yn%type;
2009:
2010: CURSOR sales_rep_csr IS
2011: SELECT SALESREP_ID, SALESREP_NUMBER
2012: FROM ra_salesreps
2013: WHERE NAME = 'No Sales Credit';
2014:
2015:
2016: CURSOR sales_type_credit_csr IS

Line 2021: l_salesrep_id ra_salesreps.SALESREP_ID%TYPE;

2017: SELECT sales_credit_type_id
2018: FROM so_sales_credit_types
2019: WHERE name = 'Quota Sales Credit';
2020:
2021: l_salesrep_id ra_salesreps.SALESREP_ID%TYPE;
2022: l_salesrep_number ra_salesreps.SALESREP_NUMBER%TYPE;
2023: l_sales_type_credit so_sales_credit_types.sales_credit_type_id%TYPE;
2024: */
2025: --end: | 02-APR-07 cklee R12 Billing enhancement project |

Line 2022: l_salesrep_number ra_salesreps.SALESREP_NUMBER%TYPE;

2018: FROM so_sales_credit_types
2019: WHERE name = 'Quota Sales Credit';
2020:
2021: l_salesrep_id ra_salesreps.SALESREP_ID%TYPE;
2022: l_salesrep_number ra_salesreps.SALESREP_NUMBER%TYPE;
2023: l_sales_type_credit so_sales_credit_types.sales_credit_type_id%TYPE;
2024: */
2025: --end: | 02-APR-07 cklee R12 Billing enhancement project |
2026: