APPS.ARP_AUTO_ACCOUNTING dependencies on RA_SALESREPS

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

1341: --
1342: -- PROCEDURE NAME: get_salesrep_ccids
1343: --
1344: -- DECSRIPTION:
1345: -- Retrieves default ccids from the table ra_salesreps
1346: -- for a given salesrep_id.
1347: --
1348: -- ARGUMENTS:
1349: -- IN:

Line 1398: FROM ra_salesreps

1394: nvl(gl_id_rev,-1),
1395: nvl(gl_id_rec,-1),
1396: nvl(gl_id_freight,-1)
1397: INTO p_ccid_rev, p_ccid_rec, p_ccid_frt
1398: FROM ra_salesreps
1399: WHERE salesrep_id = p_salesrep_id;
1400:
1401: -- update cache
1402: salesrep_rev_t( p_salesrep_id ) := p_ccid_rev;

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

4429: ELSIF p_account_class = SUSPENSE THEN
4430: l_ccid := p_ccid_record.site_use_ccid_suspense;
4431: END IF;
4432:
4433: ELSIF( l_tbl = 'RA_SALESREPS' ) THEN
4434: --
4435: -- For all account classes
4436: --
4437: IF p_account_class in (REV, CHARGES) THEN

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

7866: ------------------------------------------------------------------------
7867: BEGIN
7868:
7869: system_info.rev_based_on_salesrep :=
7870: query_autoacc_def( REV, 'RA_SALESREPS' );
7871:
7872: system_info.tax_based_on_salesrep :=
7873: query_autoacc_def( TAX, 'RA_SALESREPS' );
7874:

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

7869: system_info.rev_based_on_salesrep :=
7870: query_autoacc_def( REV, 'RA_SALESREPS' );
7871:
7872: system_info.tax_based_on_salesrep :=
7873: query_autoacc_def( TAX, 'RA_SALESREPS' );
7874:
7875: system_info.unbill_based_on_salesrep :=
7876: query_autoacc_def( UNBILL, 'RA_SALESREPS' );
7877:

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

7872: system_info.tax_based_on_salesrep :=
7873: query_autoacc_def( TAX, 'RA_SALESREPS' );
7874:
7875: system_info.unbill_based_on_salesrep :=
7876: query_autoacc_def( UNBILL, 'RA_SALESREPS' );
7877:
7878: system_info.unearn_based_on_salesrep :=
7879: query_autoacc_def( UNEARN, 'RA_SALESREPS' );
7880:

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

7875: system_info.unbill_based_on_salesrep :=
7876: query_autoacc_def( UNBILL, 'RA_SALESREPS' );
7877:
7878: system_info.unearn_based_on_salesrep :=
7879: query_autoacc_def( UNEARN, 'RA_SALESREPS' );
7880:
7881: system_info.suspense_based_on_salesrep :=
7882: query_autoacc_def( SUSPENSE, 'RA_SALESREPS' );
7883:

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

7878: system_info.unearn_based_on_salesrep :=
7879: query_autoacc_def( UNEARN, 'RA_SALESREPS' );
7880:
7881: system_info.suspense_based_on_salesrep :=
7882: query_autoacc_def( SUSPENSE, 'RA_SALESREPS' );
7883:
7884:
7885: EXCEPTION
7886: WHEN OTHERS THEN