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 647: FROM HZ_CUST_ACCOUNTS_ALL

643: where instance_id = p_instance_id;
644: --
645: CURSOR acct_from_party(p_party_id number) IS
646: SELECT count(cust_account_id)
647: FROM HZ_CUST_ACCOUNTS_ALL
648: WHERE party_id = p_party_id
649: AND NVL(status, 'A') = 'A';
650: --
651: --

Line 2812: FROM hz_cust_accounts_all

2808: IF EstDtlTab(i).account_id is null then
2809: BEGIN
2810: SELECT cust_account_id
2811: INTO l_account_id
2812: FROM hz_cust_accounts_all
2813: WHERE party_id = p_party_id
2814: AND status = 'A';
2815: EXCEPTION
2816: WHEN NO_DATA_FOUND THEN