APPS.CS_AUTOCREATE_SYSTEMS_PKG dependencies on HZ_CUST_ACCOUNTS

Line 61: -- customer from HZ_CUST_ACCOUNTS table

57:
58: SELECT sysdate INTO l_system_date FROM dual;
59:
60: -- Getting the Value for the coterminate_day_month for the current
61: -- customer from HZ_CUST_ACCOUNTS table
62: BEGIN
63:
64: SELECT coterminate_day_month
65: INTO l_coterminate_day_month

Line 66: FROM hz_cust_accounts

62: BEGIN
63:
64: SELECT coterminate_day_month
65: INTO l_coterminate_day_month
66: FROM hz_cust_accounts
67: WHERE cust_account_id = p_customer_id;
68: --AND org_id = FND_PROFILE.Value('ORG_ID');
69:
70: EXCEPTION WHEN NO_DATA_FOUND THEN