APPS.OKL_SSC_WF dependencies on HZ_CUST_ACCOUNTS

Line 3300: from HZ_CUST_ACCOUNTS

3296:
3297: -- Commented for Make Payment change
3298: /*
3299: select cust_account_id INTO l_cust_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) ; */

Line 3418: FROM hz_cust_accounts

3414: WHERE cash_receipt_id = p_payment_id;
3415:
3416: CURSOR cust_name_info_cur(p_cust_id IN NUMBER) IS
3417: SELECT account_name
3418: FROM hz_cust_accounts
3419: WHERE cust_account_id = p_cust_id;
3420:
3421: CURSOR requestor_info_cur(p_requestor_id IN NUMBER) IS
3422: SELECT user_name from fnd_user