APPS.ARP_CTLS_PKG dependencies on AR_SYSTEM_PARAMETERS

Line 5: pg_salesrep_required_flag ar_system_parameters.salesrep_required_flag%type;

1: PACKAGE BODY ARP_CTLS_PKG AS
2: /* $Header: ARTITLSB.pls 120.14.12010000.1 2008/07/24 16:57:02 appldev ship $ */
3: PG_DEBUG varchar2(1) := NVL(FND_PROFILE.value('AFLOG_ENABLED'), 'N');
4:
5: pg_salesrep_required_flag ar_system_parameters.salesrep_required_flag%type;
6:
7: /*--------------------------------------------------------+
8: | Dummy constants for use in update and lock operations |
9: +--------------------------------------------------------*/

Line 2816: FROM ar_system_parameters;

2812:
2813: ---- temporary! Remove for production. ---- moose
2814: SELECT salesrep_required_flag
2815: INTO pg_salesrep_required_flag
2816: FROM ar_system_parameters;
2817: ---- --------------------------------------
2818:
2819: /* Bug 3828325/3837548 - Bind variable adversely affects performance.
2820: Adding IF-ELSE and separate execution path to only use