APPS.HZ_EXTRACT_CUST_ACCT_BO_PVT dependencies on HZ_CUST_ACCT_RELATE

Line 18: x_cust_acct_relate_objs OUT NOCOPY HZ_CUST_ACCT_RELATE_OBJ_TBL,

14: PROCEDURE get_cust_acct_relate_objs(
15: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
16: p_cust_acct_id IN NUMBER,
17: p_action_type IN VARCHAR2 := NULL,
18: x_cust_acct_relate_objs OUT NOCOPY HZ_CUST_ACCT_RELATE_OBJ_TBL,
19: x_return_status OUT NOCOPY VARCHAR2,
20: x_msg_count OUT NOCOPY NUMBER,
21: x_msg_data OUT NOCOPY VARCHAR2
22: ) is

Line 26: SELECT HZ_CUST_ACCT_RELATE_OBJ (

22: ) is
23: l_debug_prefix VARCHAR2(30) := '';
24:
25: CURSOR C1 IS
26: SELECT HZ_CUST_ACCT_RELATE_OBJ (
27: P_ACTION_TYPE,
28: NULL, -- COMMON_OBJ_ID
29: CUST_ACCOUNT_ID,
30: RELATED_CUST_ACCOUNT_ID,

Line 107: FROM HZ_CUST_ACCT_RELATE

103: WHERE
104: OWNER_TABLE_ID = RELATED_CUST_ACCOUNT_ID
105: AND OWNER_TABLE_NAME = 'HZ_CUST_ACCOUNTS'
106: AND STATUS = 'A') AS HZ_ORIG_SYS_REF_OBJ_TBL))
107: FROM HZ_CUST_ACCT_RELATE
108: WHERE CUST_ACCOUNT_ID = P_CUST_ACCT_ID;
109:
110: BEGIN
111:

Line 602: Account Relationship N Y HZ_CUST_ACCT_RELATE

598:
599: Embedded TCA Entity Mandatory Multiple TCA Table Entities
600:
601: Customer Account Y N HZ_CUST_ACCOUNTS
602: Account Relationship N Y HZ_CUST_ACCT_RELATE
603: Bank Account Use N Y Owned by Payments team
604: Payment Method N N Owned by AR team
605:
606: */

Line 778: HZ_CUST_ACCT_RELATE_OBJ_TBL(),

774: WHERE
775: OSR.OWNER_TABLE_ID = CA.CUST_ACCOUNT_ID
776: AND OWNER_TABLE_NAME = 'HZ_CUST_ACCOUNTS'
777: AND STATUS = 'A') AS HZ_ORIG_SYS_REF_OBJ_TBL),
778: HZ_CUST_ACCT_RELATE_OBJ_TBL(),
779: HZ_CUST_ACCT_SITE_BO_TBL(),
780: HZ_CUST_ACCT_CONTACT_BO_TBL(),
781: NULL, --CUST_PROFILE_OBJ,
782: CAST(MULTISET (

Line 1062: Account Relationship N Y HZ_CUST_ACCT_RELATE

1058:
1059: Embedded TCA Entity Mandatory Multiple TCA Table Entities
1060:
1061: Customer Account Y N HZ_CUST_ACCOUNTS
1062: Account Relationship N Y HZ_CUST_ACCT_RELATE
1063: Bank Account Use N Y Owned by Payments team
1064: Payment Method N N Owned by AR team
1065:
1066: */

Line 1238: HZ_CUST_ACCT_RELATE_OBJ_TBL(),

1234: WHERE
1235: OSR.OWNER_TABLE_ID = CA.CUST_ACCOUNT_ID
1236: AND OWNER_TABLE_NAME = 'HZ_CUST_ACCOUNTS'
1237: AND STATUS = 'A') AS HZ_ORIG_SYS_REF_OBJ_TBL),
1238: HZ_CUST_ACCT_RELATE_OBJ_TBL(),
1239: HZ_CUST_ACCT_SITE_V2_BO_TBL(),
1240: HZ_CUST_ACCT_CONTACT_BO_TBL(),
1241: NULL, --CUST_PROFILE_OBJ,
1242: CAST(MULTISET (