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:
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:
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: