DBA Data[Home] [Help]

APPS.HZ_EXTRACT_CUST_ACCT_BO_PVT dependencies on HZ_BANK_ACCT_USE_OBJ

Line 783: SELECT HZ_BANK_ACCT_USE_OBJ(

779: HZ_CUST_ACCT_SITE_BO_TBL(),
780: HZ_CUST_ACCT_CONTACT_BO_TBL(),
781: NULL, --CUST_PROFILE_OBJ,
782: CAST(MULTISET (
783: SELECT HZ_BANK_ACCT_USE_OBJ(
784: P_ACTION_TYPE,
785: NULL, -- COMMON_OBJ_ID
786: INSTR_ASSIGNMENT_ID, --BANK_ACCT_USE_ID,
787: PAYMENT_FUNCTION,

Line 803: WHERE CUST_ACCOUNT_ID = CA.CUST_ACCOUNT_ID) AS HZ_BANK_ACCT_USE_OBJ_TBL),

799: CREATION_DATE,
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,

Line 1243: SELECT HZ_BANK_ACCT_USE_OBJ(

1239: HZ_CUST_ACCT_SITE_V2_BO_TBL(),
1240: HZ_CUST_ACCT_CONTACT_BO_TBL(),
1241: NULL, --CUST_PROFILE_OBJ,
1242: CAST(MULTISET (
1243: SELECT HZ_BANK_ACCT_USE_OBJ(
1244: P_ACTION_TYPE,
1245: NULL, -- COMMON_OBJ_ID
1246: INSTR_ASSIGNMENT_ID, --BANK_ACCT_USE_ID,
1247: PAYMENT_FUNCTION,

Line 1263: WHERE CUST_ACCOUNT_ID = CA.CUST_ACCOUNT_ID) AS HZ_BANK_ACCT_USE_OBJ_TBL),

1259: CREATION_DATE,
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,