APPS.ARH_CREL_PKG dependencies on HZ_CUST_ACCT_RELATE

Line 92: FROM HZ_CUST_ACCT_RELATE

88: CURSOR cu_cust_relate_version IS
89: SELECT ROWID,
90: OBJECT_VERSION_NUMBER,
91: LAST_UPDATE_DATE
92: FROM HZ_CUST_ACCT_RELATE
93: WHERE CUST_ACCOUNT_ID = p_col_id
94: AND RELATED_CUST_ACCOUNT_ID = p_col_Id2;
95:
96: l_last_update_date DATE;

Line 99: IF p_table_name = 'HZ_CUST_ACCT_RELATE' THEN

95:
96: l_last_update_date DATE;
97: BEGIN
98:
99: IF p_table_name = 'HZ_CUST_ACCT_RELATE' THEN
100: OPEN cu_cust_relate_version;
101: FETCH cu_cust_relate_version INTO
102: x_rowid ,
103: x_object_version_number,

Line 134: from hz_cust_acct_relate

130: --
131: begin
132: select count(1)
133: into duplicate_count
134: from hz_cust_acct_relate
135: where cust_account_id = x_customer_id
136: and related_cust_account_id = x_related_customer_id
137: and status = 'A'; --Bug Fix: 3237327
138:

Line 301: (p_table_name => 'HZ_CUST_ACCT_RELATE',

297: BEGIN
298: l_object_version := x_object_version;
299: IF l_object_version = -1 THEN
300: object_version_select
301: (p_table_name => 'HZ_CUST_ACCT_RELATE',
302: p_col_id => X_customer_id,
303: p_col_id2 => X_Related_Customer_Id,
304: x_rowid => l_rowid,
305: x_object_version_number => l_object_version,

Line 375: from hz_cust_acct_relate

371: --{Bug Fix: 3237327
372: IF x_row_id IS NOT NULL THEN
373: select last_update_date
374: into x_last_update_date
375: from hz_cust_acct_relate
376: where cust_account_id = X_Customer_Id
377: and related_cust_account_id = X_Related_Customer_Id
378: and rowid = X_row_id;
379: ELSE

Line 404: update hz_cust_acct_relate_all

400: --
401: --{Bug Fix: 3237327
402: IF x_return_status = 'S' THEN
403: IF x_row_id IS NOT NULL THEN
404: update hz_cust_acct_relate_all
405: set customer_reciprocal_flag = decode(x_status,
406: 'I','N',
407: 'A','Y'
408: )