APPS.CS_CHARGE_CREATE_ORDER_PVT dependencies on HZ_CUST_ACCOUNTS

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 2370: FROM hz_cust_accounts

2366: FROM CSI_I_PARTIES
2367: WHERE instance_id = EstDtlTab(i).Customer_Product_Id
2368: --AND relationship_type_code = 'OWNER' -- Bug 8209077
2369: AND party_id = (SELECT party_id
2370: FROM hz_cust_accounts
2371: WHERE cust_account_id = EstDtlTab(i).account_id);*/
2372:
2373: CURSOR c_instance_party_owner is
2374: SELECT instance_party_id,

Line 2380: FROM hz_cust_accounts

2376: FROM CSI_I_PARTIES
2377: WHERE instance_id = EstDtlTab(i).Customer_Product_Id
2378: AND relationship_type_code = 'OWNER'
2379: AND party_id = (SELECT party_id
2380: FROM hz_cust_accounts
2381: WHERE cust_account_id = EstDtlTab(i).account_id);
2382:
2383: CURSOR c_instance_party is
2384: SELECT instance_party_id,

Line 2390: FROM hz_cust_accounts

2386: FROM CSI_I_PARTIES
2387: WHERE instance_id = EstDtlTab(i).Customer_Product_Id
2388: AND relationship_type_code <> 'OWNER'
2389: AND party_id = (SELECT party_id
2390: FROM hz_cust_accounts
2391: WHERE cust_account_id = EstDtlTab(i).account_id);
2392: -- End bug 9823087
2393: k Number;
2394:

Line 2440: FROM hz_cust_accounts

2436: FROM CSI_I_PARTIES
2437: WHERE instance_id = EstDtlTab(i).Customer_Product_Id
2438: AND relationship_type_code = 'OWNER'
2439: AND party_id = (SELECT party_id
2440: FROM hz_cust_accounts
2441: WHERE cust_account_id = EstDtlTab(i).account_id);
2442:
2443: EXCEPTION
2444: WHEN OTHERS THEN

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

Line 3425: FROM hz_cust_accounts

3421: FROM CSI_I_PARTIES
3422: WHERE instance_id = EstDtlTab(i).Customer_Product_Id
3423: AND relationship_type_code = 'OWNER'
3424: AND party_id = (SELECT party_id
3425: FROM hz_cust_accounts
3426: WHERE cust_account_id = l_account_id);
3427:
3428: csi_txn_party_detail_tbl(1).instance_party_id := l_instance_party_id;
3429: csi_txn_party_detail_tbl(1).party_source_table := 'HZ_PARTIES';