APPS.CSM_EMAIL_QUERY_PKG dependencies on WF_LOCAL_ROLES

Line 2078: FROM wf_local_roles wf,

2074: IS
2075: CURSOR c_role(p_email_id VARCHAR2, p_user_id NUMBER)
2076: IS
2077: SELECT wf.name as role_name, fu.user_name as user_name
2078: FROM wf_local_roles wf,
2079: fnd_user fu
2080: WHERE wf.email_address = p_email_id
2081: AND fu.user_id = p_user_id
2082: AND wf.status = 'ACTIVE'

Line 2087: l_role_name wf_local_roles.name%type;

2083: AND wf.start_date <= sysdate
2084: AND (wf.expiration_date IS NULL OR wf.expiration_date > sysdate);
2085:
2086: l_nid NUMBER;
2087: l_role_name wf_local_roles.name%type;
2088: l_user_name fnd_user.user_name%type;
2089: l_user_id NUMBER;
2090: BEGIN
2091: