APPS.HZ_EXTRACT_CUST_ACCT_BO_PVT dependencies on HZ_PARTIES

Line 8: * @rep:category BUSINESS_ENTITY HZ_PARTIES

4: * This package contains the private APIs for logical customer account.
5: * @rep:scope private
6: * @rep:product HZ
7: * @rep:displayname customer account
8: * @rep:category BUSINESS_ENTITY HZ_PARTIES
9: * @rep:lifecycle active
10: * @rep:doccd 115hztig.pdf customer account Get APIs
11: */
12:

Line 838: FROM HZ_PARTIES P, HZ_CUST_ACCOUNTS CA

834: FROM RA_CUST_RECEIPT_METHODS CRM
835: WHERE CA.CUST_ACCOUNT_ID = CRM.CUSTOMER_ID
836: AND ROWNUM = 1)
837: )
838: FROM HZ_PARTIES P, HZ_CUST_ACCOUNTS CA
839: WHERE P.PARTY_ID = CA.PARTY_ID
840: AND ((P_CUST_ACCT_ID IS NULL AND P.PARTY_ID = P_PARENT_ID)
841: OR (P_CUST_ACCT_ID IS NOT NULL AND CA.CUST_ACCOUNT_ID = P_CUST_ACCT_ID));
842:

Line 1297: FROM HZ_PARTIES P, HZ_CUST_ACCOUNTS CA

1293: HZ_EXTRACT_BO_UTIL_PVT.GET_USER_NAME(CRM.LAST_UPDATED_BY))
1294: FROM RA_CUST_RECEIPT_METHODS CRM
1295: WHERE CA.CUST_ACCOUNT_ID = CRM.CUSTOMER_ID ) AS HZ_PAYMENT_METHOD_OBJ_TBL )
1296: )
1297: FROM HZ_PARTIES P, HZ_CUST_ACCOUNTS CA
1298: WHERE P.PARTY_ID = CA.PARTY_ID
1299: AND ((P_CUST_ACCT_ID IS NULL AND P.PARTY_ID = P_PARENT_ID)
1300: OR (P_CUST_ACCT_ID IS NOT NULL AND CA.CUST_ACCOUNT_ID = P_CUST_ACCT_ID));
1301: