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 P_AWT_Date BETWEEN gps.start_date AND gps.end_date
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 2752: l_liability_post_lookup_code AP_SYSTEM_PARAMETERS.liability_post_lookup_code%TYPE;

2748:
2749: t_bal_seg varchar2(200);
2750: Curr_Bal varchar2(200);
2751: Pre_Bal varchar2(200);
2752: l_liability_post_lookup_code AP_SYSTEM_PARAMETERS.liability_post_lookup_code%TYPE;
2753: counter number :=1 ;
2754:
2755:
2756: ----------------------------------------------------------------------

Line 2786: FROM ap_system_parameters;

2782: ----------------------------------------------------------------------------------------
2783:
2784: SELECT nvl(liability_post_lookup_code, 'NONE')
2785: INTO l_liability_post_lookup_code
2786: FROM ap_system_parameters;
2787:
2788: IF (l_Liability_Post_Lookup_Code = 'BALANCING_SEGMENT') AND
2789: (Ap_Extended_Withholding_Pkg.Ap_Extended_Withholding_Active) THEN
2790:

Line 2840: l_liability_post_lookup_code AP_SYSTEM_PARAMETERS.liability_post_lookup_code%TYPE;

2836: ) return Varchar2
2837: IS
2838:
2839: t_bal_seg varchar2(200);
2840: l_liability_post_lookup_code AP_SYSTEM_PARAMETERS.liability_post_lookup_code%TYPE;
2841: Curr_Bal varchar2(200);
2842: Pre_Bal varchar2(200);
2843: counter number :=1 ;
2844:

Line 2878: FROM ap_system_parameters;

2874: ----------------------------------------------------------------------------------------
2875:
2876: SELECT nvl(liability_post_lookup_code, 'NONE')
2877: INTO l_liability_post_lookup_code
2878: FROM ap_system_parameters;
2879:
2880:
2881: IF (l_Liability_Post_Lookup_Code = 'BALANCING_SEGMENT') AND
2882: (Ap_Extended_Withholding_Pkg.Ap_Extended_Withholding_Active) THEN