APPS.CS_CHARGE_CREATE_ORDER_PVT dependencies on HZ_CUST_ACCOUNTS_ALL

Line 46: FROM HZ_CUST_ACCOUNTS_ALL

42:
43: -- Bug 6655006
44: Cursor active_accts(p_party_id number) is
45: SELECT CUST_ACCOUNT_ID
46: FROM HZ_CUST_ACCOUNTS_ALL
47: WHERE PARTY_ID = p_party_id
48: AND STATUS = 'A';
49:
50: Cursor acct_site_csr(p_org_id number, p_party_site_id number, p_account_id number) IS

Line 103: FROM HZ_CUST_ACCOUNTS_ALL

99: BEGIN
100:
101: /* SELECT min(CUST_ACCOUNT_ID)
102: INTO x_account_id
103: FROM HZ_CUST_ACCOUNTS_ALL
104: WHERE PARTY_ID = l_party_id
105: AND STATUS = 'A'
106: AND CUST_ACCOUNT_ID is not null;*/
107: /*

Line 112: FROM HZ_CUST_ACCOUNTS_ALL h1

108: --Begin : Bug# 4870037
109: IF p_site_use_flag = 'B' THEN
110: SELECT min(CUST_ACCOUNT_ID)
111: INTO x_account_id
112: FROM HZ_CUST_ACCOUNTS_ALL h1
113: WHERE h1.PARTY_ID = l_party_id
114: AND h1.STATUS = 'A'
115: AND h1.CUST_ACCOUNT_ID is not null
116: AND EXISTS (SELECT '1' FROM hz_cust_acct_sites_all h2

Line 125: FROM HZ_CUST_ACCOUNTS_ALL h1

121: AND h2.BILL_TO_FLAG = 'Y');
122: ELSIF p_site_use_flag = 'S' THEN
123: SELECT min(CUST_ACCOUNT_ID)
124: INTO x_account_id
125: FROM HZ_CUST_ACCOUNTS_ALL h1
126: WHERE h1.PARTY_ID = l_party_id
127: AND h1.STATUS = 'A'
128: AND h1.CUST_ACCOUNT_ID is not null
129: AND EXISTS (SELECT '1' FROM hz_cust_acct_sites_all h2

Line 681: FROM HZ_CUST_ACCOUNTS_ALL

677: where instance_id = p_instance_id;
678: --
679: CURSOR acct_from_party(p_party_id number) IS
680: SELECT count(cust_account_id)
681: FROM HZ_CUST_ACCOUNTS_ALL
682: WHERE party_id = p_party_id
683: AND NVL(status, 'A') = 'A';
684: --
685: --

Line 3384: FROM hz_cust_accounts_all

3380: IF EstDtlTab(i).account_id is null then
3381: BEGIN
3382: SELECT cust_account_id
3383: INTO l_account_id
3384: FROM hz_cust_accounts_all
3385: WHERE party_id = p_party_id
3386: AND status = 'A';
3387: EXCEPTION
3388: WHEN NO_DATA_FOUND THEN