APPS.OKL_SSC_WF dependencies on OKL_SYSTEM_PARAMS_ALL

Line 3281: FROM okl_system_params_all

3277:
3278: -- Get receipt method id
3279: CURSOR c_get_irm(lorg_id Number) IS
3280: SELECT ccard_remittance_id rm_id
3281: FROM okl_system_params_all
3282: WHERE org_id = lorg_id ;
3283: -- Get site use id
3284: Cursor c_get_site_use (l_inv_id Number)
3285: IS

Line 3304: pl_irm_id := OKL_SYSTEM_PARAMS_ALL_PUB.get_system_param_value(OKL_SYSTEM_PARAMS_ALL_PUB.G_CCARD_REMITTANCE_ID) ; */

3300: from HZ_CUST_ACCOUNTS
3301: where account_number = p_custid;--Smoduga removed char conversion
3302: --as p_cust_id is of type varchar2.4055222
3303: --modified by akrangan on 28.7.06 MOAC Changes
3304: pl_irm_id := OKL_SYSTEM_PARAMS_ALL_PUB.get_system_param_value(OKL_SYSTEM_PARAMS_ALL_PUB.G_CCARD_REMITTANCE_ID) ; */
3305:
3306: For K In c_get_irm(l_org_id)
3307: Loop
3308: pl_irm_id:=K.rm_id;