APPS.JL_INTERFACE_VAL dependencies on AP_SYSTEM_PARAMETERS

Line 345: l_liability_post_lookup_code AP_SYSTEM_PARAMETERS.liability_post_lookup_code%TYPE;

341: IF (l_country_code = 'CO') THEN
342:
343: Declare
344: invo_id number;
345: l_liability_post_lookup_code AP_SYSTEM_PARAMETERS.liability_post_lookup_code%TYPE;
346: validate_error varchar2(200);
347: l_cursor NUMBER;
348: l_sqlstmt VARCHAR2(1000);
349: l_ignore NUMBER;

Line 362: FROM ap_system_parameters;

358: ----------------------------------------------------------------------------------------
359:
360: SELECT nvl(liability_post_lookup_code, 'NONE')
361: INTO l_liability_post_lookup_code
362: FROM ap_system_parameters;
363:
364:
365: IF (l_Liability_Post_Lookup_Code = 'BALANCING_SEGMENT') AND
366: (Ap_Extended_Withholding_Pkg.Ap_Extended_Withholding_Active) THEN

Line 746: l_liability_post_lookup_code AP_SYSTEM_PARAMETERS.liability_post_lookup_code%TYPE;

742: -- Call to check for multiple balancing segments
743: -- Get Set of Books and Auto-offsets Option info
744: ----------------------------------------------------------------------------------------
745: Declare
746: l_liability_post_lookup_code AP_SYSTEM_PARAMETERS.liability_post_lookup_code%TYPE;
747: validate_error varchar2(200);
748: l_cursor NUMBER;
749: l_sqlstmt VARCHAR2(1000);
750: l_ignore NUMBER;

Line 755: FROM ap_system_parameters;

751:
752: Begin
753: SELECT nvl(liability_post_lookup_code, 'NONE')
754: INTO l_liability_post_lookup_code
755: FROM ap_system_parameters;
756:
757: IF (l_Liability_Post_Lookup_Code = 'BALANCING_SEGMENT') AND
758: (Ap_Extended_Withholding_Pkg.Ap_Extended_Withholding_Active) THEN
759: