APPS.HZ_EXTRACT_ACCT_SITE_BO_PVT dependencies on HZ_BANK_ACCT_USE_OBJ

Line 513: SELECT HZ_BANK_ACCT_USE_OBJ(

509: AND OWNER_TABLE_NAME = 'HZ_CUST_SITE_USES_ALL'
510: AND STATUS = 'A') AS HZ_ORIG_SYS_REF_OBJ_TBL),
511: NULL, --HZ_CUSTOMER_PROFILE_BO
512: CAST(MULTISET (
513: SELECT HZ_BANK_ACCT_USE_OBJ(
514: P_ACTION_TYPE,
515: NULL, -- COMMON_OBJ_ID
516: INSTR_ASSIGNMENT_ID, --BANK_ACCT_USE_ID,
517: PAYMENT_FUNCTION,

Line 533: WHERE ACCT_SITE_USE_ID = CSU.SITE_USE_ID) AS HZ_BANK_ACCT_USE_OBJ_TBL),

529: NULL, --CREATION_DATE,
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,

Line 1259: SELECT HZ_BANK_ACCT_USE_OBJ(

1255: AND OWNER_TABLE_NAME = 'HZ_CUST_SITE_USES_ALL'
1256: AND STATUS = 'A') AS HZ_ORIG_SYS_REF_OBJ_TBL),
1257: NULL, --HZ_CUSTOMER_PROFILE_BO
1258: CAST(MULTISET (
1259: SELECT HZ_BANK_ACCT_USE_OBJ(
1260: P_ACTION_TYPE,
1261: NULL, -- COMMON_OBJ_ID
1262: INSTR_ASSIGNMENT_ID, --BANK_ACCT_USE_ID,
1263: PAYMENT_FUNCTION,

Line 1279: WHERE ACCT_SITE_USE_ID = CSU.SITE_USE_ID) AS HZ_BANK_ACCT_USE_OBJ_TBL),

1275: NULL, --CREATION_DATE,
1276: ASSIGNMENT_LAST_UPDATE,
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