APPS.MRP_EXP_WF dependencies on HZ_CUST_ACCOUNT_ROLES

Line 1135: hz_cust_account_roles cont

1131: CURSOR CUSTOMER_CONTACT_C1(p_customer_id in number) IS
1132: SELECT DECODE(fu.employee_id, NULL, fu.user_id, fu.employee_id),
1133: DECODE(fu.employee_id, NULL, 'FND_USR', 'PER')
1134: FROM fnd_user fu,
1135: hz_cust_account_roles cont
1136: WHERE fu.customer_id = cont.cust_account_role_id
1137: AND cont.cust_account_id = p_customer_id;
1138:
1139: CURSOR CUSTOMER_CONTACT_C2(p_customer_id in number) IS

Line 1141: FROM hz_cust_account_roles

1137: AND cont.cust_account_id = p_customer_id;
1138:
1139: CURSOR CUSTOMER_CONTACT_C2(p_customer_id in number) IS
1140: SELECT cust_account_role_id
1141: FROM hz_cust_account_roles
1142: WHERE cust_account_id = p_customer_id;
1143:
1144: l_person_id number;
1145: l_orig_system varchar2(48);