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

2121: FROM CSI_I_PARTIES
2122: WHERE instance_id = EstDtlTab(i).Customer_Product_Id
2123: AND relationship_type_code = 'OWNER'
2124: AND party_id = (SELECT party_id
2125: FROM hz_cust_accounts
2126: WHERE cust_account_id = EstDtlTab(i).account_id);
2127:
2128: EXCEPTION
2129: WHEN OTHERS THEN

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

Line 2853: FROM hz_cust_accounts

2849: FROM CSI_I_PARTIES
2850: WHERE instance_id = EstDtlTab(i).Customer_Product_Id
2851: AND relationship_type_code = 'OWNER'
2852: AND party_id = (SELECT party_id
2853: FROM hz_cust_accounts
2854: WHERE cust_account_id = l_account_id);
2855:
2856: csi_txn_party_detail_tbl(1).instance_party_id := l_instance_party_id;
2857: csi_txn_party_detail_tbl(1).party_source_table := 'HZ_PARTIES';