APPS.ARI_SERVICE_CHARGE_PKG dependencies on AR_LOOKUPS

Line 189: -- fnd_lookup_values, ar_lookups

185: L_SERVICE_CHRG_PRCNT := 0.05;
186: L_LOOKUP_TYPE := null;
187: end if;
188:
189: -- fnd_lookup_values, ar_lookups
190: IF P_LOOKUP_CODE IS NOT NULL THEN
191: BEGIN
192: SELECT ATTRIBUTE1 INTO L_SERVICE_CHRG_PRCNT from ar_lookups where lookup_type = upper(L_LOOKUP_TYPE) AND lookup_code = upper(P_LOOKUP_CODE)
193: AND ENABLED_FLAG='Y' and sysdate between start_date_active and nvl(end_date_active,sysdate);

Line 192: SELECT ATTRIBUTE1 INTO L_SERVICE_CHRG_PRCNT from ar_lookups where lookup_type = upper(L_LOOKUP_TYPE) AND lookup_code = upper(P_LOOKUP_CODE)

188:
189: -- fnd_lookup_values, ar_lookups
190: IF P_LOOKUP_CODE IS NOT NULL THEN
191: BEGIN
192: SELECT ATTRIBUTE1 INTO L_SERVICE_CHRG_PRCNT from ar_lookups where lookup_type = upper(L_LOOKUP_TYPE) AND lookup_code = upper(P_LOOKUP_CODE)
193: AND ENABLED_FLAG='Y' and sysdate between start_date_active and nvl(end_date_active,sysdate);
194: EXCEPTION
195: WHEN OTHERS THEN
196: arp_standard.debug('Unexpected Exception in ' || G_PKG_NAME || l_procedure_name);