DBA Data[Home] [Help]

APPS.HZ_EXTRACT_ACCT_SITE_BO_PVT dependencies on HZ_PAYMENT_METHOD_OBJ

Line 534: ( SELECT HZ_PAYMENT_METHOD_OBJ(

530: ASSIGNMENT_LAST_UPDATE,
531: NULL) --HZ_EXTRACT_BO_UTIL_PVT.GET_USER_NAME(LAST_UPDATED_BY))
532: FROM IBY_FNDCPT_PAYER_ASSGN_INSTR_V
533: WHERE ACCT_SITE_USE_ID = CSU.SITE_USE_ID) AS HZ_BANK_ACCT_USE_OBJ_TBL),
534: ( SELECT HZ_PAYMENT_METHOD_OBJ(
535: P_ACTION_TYPE,
536: NULL, -- COMMON_OBJ_ID
537: CRM.CUST_RECEIPT_METHOD_ID, --PAYMENT_METHOD_ID,
538: CRM.CUSTOMER_ID,

Line 1281: SELECT HZ_PAYMENT_METHOD_OBJ(

1277: NULL) --HZ_EXTRACT_BO_UTIL_PVT.GET_USER_NAME(LAST_UPDATED_BY))
1278: FROM IBY_FNDCPT_PAYER_ASSGN_INSTR_V
1279: WHERE ACCT_SITE_USE_ID = CSU.SITE_USE_ID) AS HZ_BANK_ACCT_USE_OBJ_TBL),
1280: CAST( MULTISET (
1281: SELECT HZ_PAYMENT_METHOD_OBJ(
1282: P_ACTION_TYPE,
1283: NULL, -- COMMON_OBJ_ID
1284: CRM.CUST_RECEIPT_METHOD_ID, --PAYMENT_METHOD_ID,
1285: CRM.CUSTOMER_ID,

Line 1312: WHERE CSU.SITE_USE_ID = CRM.SITE_USE_ID ) AS HZ_PAYMENT_METHOD_OBJ_TBL)

1308: CRM.CREATION_DATE,
1309: CRM.LAST_UPDATE_DATE,
1310: HZ_EXTRACT_BO_UTIL_PVT.GET_USER_NAME(CRM.LAST_UPDATED_BY))
1311: FROM RA_CUST_RECEIPT_METHODS CRM
1312: WHERE CSU.SITE_USE_ID = CRM.SITE_USE_ID ) AS HZ_PAYMENT_METHOD_OBJ_TBL)
1313: )
1314: FROM HZ_CUST_SITE_USES CSU
1315: WHERE CUST_ACCT_SITE_ID = P_CUST_ACCT_SITE_ID;
1316: