DBA Data[Home] [Help]

APPS.OKL_SSC_WF dependencies on OKL_SYSTEM_PARAMS_ALL

Line 3195: FROM okl_system_params_all

3191:
3192: -- Get receipt method id
3193: CURSOR c_get_irm(lorg_id Number) IS
3194: SELECT ccard_remittance_id rm_id
3195: FROM okl_system_params_all
3196: WHERE org_id = lorg_id ;
3197: -- Get site use id
3198: Cursor c_get_site_use (l_inv_id Number)
3199: IS

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

3214: from HZ_CUST_ACCOUNTS
3215: where account_number = p_custid;--Smoduga removed char conversion
3216: --as p_cust_id is of type varchar2.4055222
3217: --modified by akrangan on 28.7.06 MOAC Changes
3218: pl_irm_id := OKL_SYSTEM_PARAMS_ALL_PUB.get_system_param_value(OKL_SYSTEM_PARAMS_ALL_PUB.G_CCARD_REMITTANCE_ID) ; */
3219:
3220: For K In c_get_irm(l_org_id)
3221: Loop
3222: pl_irm_id:=K.rm_id;