DBA Data[Home] [Help]

APPS.HZ_EXTRACT_CUST_ACCT_BO_PVT dependencies on HZ_PAYMENT_METHOD_OBJ

Line 804: (SELECT HZ_PAYMENT_METHOD_OBJ(

800: ASSIGNMENT_LAST_UPDATE,
801: HZ_EXTRACT_BO_UTIL_PVT.GET_USER_NAME(LAST_UPDATED_BY))
802: FROM IBY_FNDCPT_PAYER_ASSGN_INSTR_V
803: WHERE CUST_ACCOUNT_ID = CA.CUST_ACCOUNT_ID) AS HZ_BANK_ACCT_USE_OBJ_TBL),
804: (SELECT HZ_PAYMENT_METHOD_OBJ(
805: P_ACTION_TYPE,
806: NULL, -- COMMON_OBJ_ID
807: CRM.CUST_RECEIPT_METHOD_ID, --PAYMENT_METHOD_ID,
808: CRM.CUSTOMER_ID,

Line 1264: CAST( MULTISET ( SELECT HZ_PAYMENT_METHOD_OBJ(

1260: ASSIGNMENT_LAST_UPDATE,
1261: HZ_EXTRACT_BO_UTIL_PVT.GET_USER_NAME(LAST_UPDATED_BY))
1262: FROM IBY_FNDCPT_PAYER_ASSGN_INSTR_V
1263: WHERE CUST_ACCOUNT_ID = CA.CUST_ACCOUNT_ID) AS HZ_BANK_ACCT_USE_OBJ_TBL),
1264: CAST( MULTISET ( SELECT HZ_PAYMENT_METHOD_OBJ(
1265: P_ACTION_TYPE,
1266: NULL, -- COMMON_OBJ_ID
1267: CRM.CUST_RECEIPT_METHOD_ID, --PAYMENT_METHOD_ID,
1268: CRM.CUSTOMER_ID,

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)