APPS.ARP_AUTO_ACCOUNTING dependencies on RA_SALESREPS

Line 1341: -- Retrieves default ccids from the table ra_salesreps

1337: --
1338: -- PROCEDURE NAME: get_salesrep_ccids
1339: --
1340: -- DECSRIPTION:
1341: -- Retrieves default ccids from the table ra_salesreps
1342: -- for a given salesrep_id.
1343: --
1344: -- ARGUMENTS:
1345: -- IN:

Line 1394: FROM ra_salesreps

1390: nvl(gl_id_rev,-1),
1391: nvl(gl_id_rec,-1),
1392: nvl(gl_id_freight,-1)
1393: INTO p_ccid_rev, p_ccid_rec, p_ccid_frt
1394: FROM ra_salesreps
1395: WHERE salesrep_id = p_salesrep_id;
1396:
1397: -- update cache
1398: salesrep_rev_t( p_salesrep_id ) := p_ccid_rev;

Line 4406: ELSIF( l_tbl = 'RA_SALESREPS' ) THEN

4402: ELSIF p_account_class = SUSPENSE THEN
4403: l_ccid := p_ccid_record.site_use_ccid_suspense;
4404: END IF;
4405:
4406: ELSIF( l_tbl = 'RA_SALESREPS' ) THEN
4407: --
4408: -- For all account classes
4409: --
4410: IF p_account_class in (REV, CHARGES) THEN

Line 7762: query_autoacc_def( REV, 'RA_SALESREPS' );

7758: ------------------------------------------------------------------------
7759: BEGIN
7760:
7761: system_info.rev_based_on_salesrep :=
7762: query_autoacc_def( REV, 'RA_SALESREPS' );
7763:
7764: system_info.tax_based_on_salesrep :=
7765: query_autoacc_def( TAX, 'RA_SALESREPS' );
7766:

Line 7765: query_autoacc_def( TAX, 'RA_SALESREPS' );

7761: system_info.rev_based_on_salesrep :=
7762: query_autoacc_def( REV, 'RA_SALESREPS' );
7763:
7764: system_info.tax_based_on_salesrep :=
7765: query_autoacc_def( TAX, 'RA_SALESREPS' );
7766:
7767: system_info.unbill_based_on_salesrep :=
7768: query_autoacc_def( UNBILL, 'RA_SALESREPS' );
7769:

Line 7768: query_autoacc_def( UNBILL, 'RA_SALESREPS' );

7764: system_info.tax_based_on_salesrep :=
7765: query_autoacc_def( TAX, 'RA_SALESREPS' );
7766:
7767: system_info.unbill_based_on_salesrep :=
7768: query_autoacc_def( UNBILL, 'RA_SALESREPS' );
7769:
7770: system_info.unearn_based_on_salesrep :=
7771: query_autoacc_def( UNEARN, 'RA_SALESREPS' );
7772:

Line 7771: query_autoacc_def( UNEARN, 'RA_SALESREPS' );

7767: system_info.unbill_based_on_salesrep :=
7768: query_autoacc_def( UNBILL, 'RA_SALESREPS' );
7769:
7770: system_info.unearn_based_on_salesrep :=
7771: query_autoacc_def( UNEARN, 'RA_SALESREPS' );
7772:
7773: system_info.suspense_based_on_salesrep :=
7774: query_autoacc_def( SUSPENSE, 'RA_SALESREPS' );
7775:

Line 7774: query_autoacc_def( SUSPENSE, 'RA_SALESREPS' );

7770: system_info.unearn_based_on_salesrep :=
7771: query_autoacc_def( UNEARN, 'RA_SALESREPS' );
7772:
7773: system_info.suspense_based_on_salesrep :=
7774: query_autoacc_def( SUSPENSE, 'RA_SALESREPS' );
7775:
7776:
7777: EXCEPTION
7778: WHEN OTHERS THEN