APPS.OKL_SSC_WF dependencies on HZ_CUST_ACCOUNTS

Line 3214: from HZ_CUST_ACCOUNTS

3210:
3211: -- Commented for Make Payment change
3212: /*
3213: select cust_account_id INTO l_cust_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) ; */

Line 3332: FROM hz_cust_accounts

3328: WHERE cash_receipt_id = p_payment_id;
3329:
3330: CURSOR cust_name_info_cur(p_cust_id IN NUMBER) IS
3331: SELECT account_name
3332: FROM hz_cust_accounts
3333: WHERE cust_account_id = p_cust_id;
3334:
3335: CURSOR requestor_info_cur(p_requestor_id IN NUMBER) IS
3336: SELECT user_name from fnd_user