DBA Data[Home] [Help]

APPS.IBU_REQ_PKG dependencies on WF_ROLES

Line 1253: select name from wf_roles

1249: temp_role_name varchar2(100) := null;
1250: temp_pref_name varchar2(100) := null;
1251: constructNewRoleName boolean := true;
1252: cursor cur_sr_email_cus_role(p_contact_id number, p_email_address varchar2) is
1253: select name from wf_roles
1254: where orig_system = 'HZ_PARTY'
1255: and orig_system_id = p_contact_id
1256: and email_address = p_email_address;
1257:

Line 1259: select notification_preference, name from wf_roles

1255: and orig_system_id = p_contact_id
1256: and email_address = p_email_address;
1257:
1258: cursor cur_sr_email_emp_role(p_contact_id number, p_email_address varchar2) is
1259: select notification_preference, name from wf_roles
1260: where orig_system = 'PER'
1261: and orig_system_id = p_contact_id
1262: and email_address = p_email_address;
1263: