APPS.JL_ZZ_AP_WITHHOLDING_PKG dependencies on AP_SYSTEM_PARAMETERS

Line 175: FROM ap_system_parameters;

171: SELECT nvl(create_awt_dists_type, 'NEVER'),
172: nvl(create_awt_invoices_type, 'NEVER')
173: INTO l_create_distr,
174: l_create_invoices
175: FROM ap_system_parameters;
176:
177: P_Create_Distr := l_create_distr;
178: P_Create_Invoices := l_create_invoices;
179:

Line 226: ap_system_parameters asp

222: ----------------------------------
223: SELECT gps.period_name
224: INTO l_gl_period_name
225: FROM gl_period_statuses gps,
226: ap_system_parameters asp
227: WHERE gps.application_id = 200
228: AND gps.set_of_books_id = asp.set_of_books_id
229: AND trunc(P_AWT_Date) BETWEEN trunc(gps.start_date) AND trunc(gps.end_date) --bug9869654
230: AND gps.closing_status IN ('O', 'F');

Line 281: FROM ap_system_parameters;

277: -- Obtains functional currency code
278: ------------------------------------
279: SELECT base_currency_code
280: INTO l_base_currency_code
281: FROM ap_system_parameters;
282:
283: RETURN l_base_currency_code;
284:
285: EXCEPTION

Line 2707: l_liability_post_lookup_code AP_SYSTEM_PARAMETERS.liability_post_lookup_code%TYPE;

2703:
2704: t_bal_seg varchar2(200);
2705: Curr_Bal varchar2(200);
2706: Pre_Bal varchar2(200);
2707: l_liability_post_lookup_code AP_SYSTEM_PARAMETERS.liability_post_lookup_code%TYPE;
2708: counter number :=1 ;
2709:
2710:
2711: ----------------------------------------------------------------------

Line 2744: FROM ap_system_parameters;

2740: ----------------------------------------------------------------------------------------
2741:
2742: SELECT nvl(liability_post_lookup_code, 'NONE')
2743: INTO l_liability_post_lookup_code
2744: FROM ap_system_parameters;
2745:
2746: IF (l_Liability_Post_Lookup_Code = 'BALANCING_SEGMENT') AND
2747: (Ap_Extended_Withholding_Pkg.Ap_Extended_Withholding_Active) THEN
2748:

Line 2798: l_liability_post_lookup_code AP_SYSTEM_PARAMETERS.liability_post_lookup_code%TYPE;

2794: ) return Varchar2
2795: IS
2796:
2797: t_bal_seg varchar2(200);
2798: l_liability_post_lookup_code AP_SYSTEM_PARAMETERS.liability_post_lookup_code%TYPE;
2799: Curr_Bal varchar2(200);
2800: Pre_Bal varchar2(200);
2801: counter number :=1 ;
2802:

Line 2836: FROM ap_system_parameters;

2832: ----------------------------------------------------------------------------------------
2833:
2834: SELECT nvl(liability_post_lookup_code, 'NONE')
2835: INTO l_liability_post_lookup_code
2836: FROM ap_system_parameters;
2837:
2838:
2839: IF (l_Liability_Post_Lookup_Code = 'BALANCING_SEGMENT') AND
2840: (Ap_Extended_Withholding_Pkg.Ap_Extended_Withholding_Active) THEN