APPS.ARH_DQM_CUST_HELPER dependencies on HZ_CUST_ACCOUNT_ROLES

Line 13: FROM hz_cust_account_roles car,

9: IS
10: ret VARCHAR2(1);
11: CURSOR c_exist IS
12: SELECT 'Y'
13: FROM hz_cust_account_roles car,
14: hz_cust_accounts ca,
15: hz_matched_parties_gt mp
16: WHERE car.cust_account_role_id = p_cust_account_role_id
17: AND car.cust_account_id = ca.cust_account_id

Line 75: hz_cust_account_roles b

71: IS
72: CURSOR c1 IS
73: SELECT 'Y'
74: FROM hz_matched_contacts_gt a,
75: hz_cust_account_roles b
76: WHERE a.search_context_id = p_ctx_id
77: AND -a.party_id = p_cust_account_id
78: AND -a.org_contact_id = p_cust_account_role_id
79: AND b.cust_account_role_id = p_cust_account_role_id

Line 398: -- Treatement for HZ_CUST_ACCOUNT_ROLES

394: END;
395:
396: PROCEDURE ins_ca_car_in_gt
397: -------------------------------------------------------------------
398: -- Treatement for HZ_CUST_ACCOUNT_ROLES
399: -------------------------------------------------------------------
400: ( p_ctx_id IN NUMBER,
401: p_org_contact_id IN NUMBER,
402: p_cur_all IN VARCHAR2,

Line 414: hz_cust_account_roles d,

410: d.cust_acct_site_id
411: FROM hz_matched_contacts_gt a,
412: hz_org_contacts b,
413: hz_relationships c,
414: hz_cust_account_roles d,
415: hz_cust_accounts e,
416: hz_matched_parties_gt f,
417: hz_parties g
418: WHERE a.search_context_id = p_ctx_id