APPS.JL_BR_INTEREST_HANDLING dependencies on AP_SYSTEM_PARAMETERS

Line 65: -- Validate Tolerance from ap_system_parameters

61: fnd_file.put_line(FND_FILE.LOG,l_debug_info);
62: END IF;
63:
64: --
65: -- Validate Tolerance from ap_system_parameters
66: --
67: SELECT nvl(interest_tolerance_amount,0)
68: Into C_interest_tolerance_amount
69: FROM ap_system_parameters_all

Line 69: FROM ap_system_parameters_all

65: -- Validate Tolerance from ap_system_parameters
66: --
67: SELECT nvl(interest_tolerance_amount,0)
68: Into C_interest_tolerance_amount
69: FROM ap_system_parameters_all
70: WHERE nvl(org_id,-99) = nvl(x_org_id,-99);
71:
72:
73: /***

Line 76: FROM ap_system_parameters;

72:
73: /***
74: SELECT nvl(interest_tolerance_amount,0)
75: INTO C_interest_tolerance_amount
76: FROM ap_system_parameters;
77: ***/
78:
79:
80: l_debug_info := 'jlbr tolerance_amount '||to_char(C_interest_tolerance_amount);

Line 228: -- Validate Tolerance from ap_system_parameters

224: X_Days_Late := 0;
225:
226: P_Date_Ok := X_Due_Date + NVL(X_Grace_Days,0);
227: --
228: -- Validate Tolerance from ap_system_parameters
229: --
230: SELECT nvl(interest_tolerance_amount,0)
231: INTO C_interest_tolerance_amount
232: FROM ap_system_parameters;

Line 232: FROM ap_system_parameters;

228: -- Validate Tolerance from ap_system_parameters
229: --
230: SELECT nvl(interest_tolerance_amount,0)
231: INTO C_interest_tolerance_amount
232: FROM ap_system_parameters;
233:
234:
235: jl_br_workday_calendar.jl_br_check_date(to_char(P_Date_Ok, 'DD-MM-YYYY'),
236: X_JLBR_Calendar,

Line 432: -- Validate Tolerance from ap_system_parameters

428: X_Days_Late := 0;
429:
430: P_Date_Ok := X_Due_Date + NVL(X_Grace_Days,0);
431: --
432: -- Validate Tolerance from ap_system_parameters
433: --
434: SELECT nvl(interest_tolerance_amount,0)
435: INTO C_interest_tolerance_amount
436: FROM ap_system_parameters;

Line 436: FROM ap_system_parameters;

432: -- Validate Tolerance from ap_system_parameters
433: --
434: SELECT nvl(interest_tolerance_amount,0)
435: INTO C_interest_tolerance_amount
436: FROM ap_system_parameters;
437:
438:
439: jl_br_workday_calendar.jl_br_check_date(to_char(P_Date_Ok, 'DD-MM-YYYY'),
440: X_JLBR_Calendar,

Line 538: -- Validate Tolerance from ap_system_parameters

534: X_Days_Late := 0;
535:
536: P_Date_Ok := X_Due_Date + NVL(X_Grace_Days,0);
537: --
538: -- Validate Tolerance from ap_system_parameters
539: --
540: SELECT nvl(interest_tolerance_amount,0)
541: INTO C_interest_tolerance_amount
542: FROM ap_system_parameters_all --bug 13244476

Line 542: FROM ap_system_parameters_all --bug 13244476

538: -- Validate Tolerance from ap_system_parameters
539: --
540: SELECT nvl(interest_tolerance_amount,0)
541: INTO C_interest_tolerance_amount
542: FROM ap_system_parameters_all --bug 13244476
543: WHERE nvl(org_id,-99) = nvl(x_org_id,-99); --bug 13244476
544:
545:
546: jl_br_workday_calendar.jl_br_check_date(to_char(P_Date_Ok, 'DD-MM-YYYY'),