APPS.AR_DEPOSIT_API_PUB dependencies on RA_SALESREPS

Line 550: l_salesrep_id ra_salesreps.salesrep_id%type;

546: l_ctt_bs_default_type_name ra_cust_trx_types.name%type;
547: l_batch_source_id ra_batch_sources.batch_source_id%type;
548: l_cust_trx_type_id ra_cust_trx_types.cust_trx_type_id%type;
549: l_term_id ra_terms.term_id%type;
550: l_salesrep_id ra_salesreps.salesrep_id%type;
551: l_default_salesrep_id ra_salesreps.salesrep_id%type;
552: l_dft_bill_to_contact_id Number;
553: l_printing_pending ra_customer_trx_all.printing_pending%type;
554: l_doc_sequence_id NUMBER;

Line 551: l_default_salesrep_id ra_salesreps.salesrep_id%type;

547: l_batch_source_id ra_batch_sources.batch_source_id%type;
548: l_cust_trx_type_id ra_cust_trx_types.cust_trx_type_id%type;
549: l_term_id ra_terms.term_id%type;
550: l_salesrep_id ra_salesreps.salesrep_id%type;
551: l_default_salesrep_id ra_salesreps.salesrep_id%type;
552: l_dft_bill_to_contact_id Number;
553: l_printing_pending ra_customer_trx_all.printing_pending%type;
554: l_doc_sequence_id NUMBER;
555: l_doc_sequence_value VARCHAR2(50);

Line 1643: l_salesrep_number ra_salesreps.salesrep_number%type;

1639:
1640: l_deposit_number ra_customer_trx.trx_number%type;
1641: l_deposit_date ra_customer_trx.trx_date%type;
1642: l_customer_trx_id ra_cust_trx_line_salesreps.customer_trx_id%type;
1643: l_salesrep_number ra_salesreps.salesrep_number%type;
1644: l_salesrep_id ra_cust_trx_line_salesreps.salesrep_id%type;
1645: l_non_revenue_amount_split ra_cust_trx_line_salesreps.non_revenue_amount_split%type;
1646: l_non_revenue_percent_split ra_cust_trx_line_salesreps.non_revenue_percent_split%type;
1647: l_desc_flex_rec ar_deposit_api_pub.attr_rec_type;

Line 1844: FROM ra_salesreps

1840:
1841: begin
1842: SELECT salesrep_id
1843: INTO l_salesrep_id
1844: FROM ra_salesreps
1845: WHERE SALESREP_NUMBER = p_salesrep_number and
1846: NVL(status,'A') ='A' and
1847: l_deposit_date between nvl(start_date_active, l_deposit_date) and
1848: nvl(end_date_active, l_deposit_date);

Line 1863: FROM ra_salesreps

1859:
1860: begin
1861: SELECT salesrep_id
1862: INTO l_salesrep_id
1863: FROM ra_salesreps
1864: WHERE salesrep_id = p_salesrep_id and
1865: NVL(status,'A') ='A' and
1866: l_deposit_date between nvl(start_date_active, l_deposit_date) and
1867: nvl(end_date_active, l_deposit_date);