DBA Data[Home] [Help]

APPS.HZ_CUSTOMER_INT dependencies on HZ_CUST_ACCOUNT_ROLES

Line 62: FROM hz_cust_account_roles

58: RETURN NUMBER IS
59: l_cust_account_role_id NUMBER;
60: CURSOR c3 IS
61: SELECT cust_account_role_id
62: FROM hz_cust_account_roles
63: WHERE orig_system_reference = p_orig_system_contact_ref;
64: BEGIN
65: OPEN c3;
66: FETCH c3 INTO l_cust_account_role_id;

Line 81: FROM hz_cust_account_roles

77: RETURN NUMBER IS
78: l_prel_party_id NUMBER;
79: CURSOR c4 IS
80: SELECT party_id
81: FROM hz_cust_account_roles
82: WHERE orig_system_reference = p_orig_system_contact_ref;
83: BEGIN
84: OPEN c4;
85: FETCH c4 INTO l_prel_party_id;