DBA Data[Home] [Help]

APPS.HZ_EXTRACT_CUST_ACCT_BO_PVT dependencies on HZ_PAYMENT_METHOD_OBJ_TBL

Line 1295: WHERE CA.CUST_ACCOUNT_ID = CRM.CUSTOMER_ID ) AS HZ_PAYMENT_METHOD_OBJ_TBL )

1291: CRM.CREATION_DATE,
1292: CRM.LAST_UPDATE_DATE,
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)