APPS.IBU_REQ_PKG dependencies on WF_ROLES

Line 1339: select name from wf_roles

1335: temp_role_name varchar2(220) := null;
1336: temp_pref_name varchar2(100) := null;
1337: constructNewRoleName boolean := true;
1338: cursor cur_sr_email_cus_role(p_contact_id number, p_email_address varchar2) is
1339: select name from wf_roles
1340: where orig_system = 'HZ_PARTY'
1341: and orig_system_id = p_contact_id
1342: and email_address = p_email_address;
1343:

Line 1345: select notification_preference, name from wf_roles

1341: and orig_system_id = p_contact_id
1342: and email_address = p_email_address;
1343:
1344: cursor cur_sr_email_emp_role(p_contact_id number, p_email_address varchar2) is
1345: select notification_preference, name from wf_roles
1346: where orig_system = 'PER'
1347: and orig_system_id = p_contact_id
1348: and email_address = p_email_address;
1349: