APPS.AZW_REPORT dependencies on WF_ROLES

Line 4050: p_display_name wf_roles.display_name%TYPE;

4046: p_days IN VARCHAR2,
4047: p_start IN VARCHAR2,
4048: p_end IN VARCHAR2) IS
4049:
4050: p_display_name wf_roles.display_name%TYPE;
4051: v_locator PLS_INTEGER := 0;
4052: BEGIN
4053:
4054: htp.p('');

Line 4063: FROM wf_roles

4059: htp.p('

' || g_user || '

'); 4060: v_locator := 1; 4061: IF (p_user IS NOT NULL) THEN 4062: SELECT display_name INTO p_display_name 4063: FROM wf_roles 4064: WHERE name = p_user; 4065: htp.p(p_user || ' (' || p_display_name || ')'); 4066: ELSE 4067: htp.p(g_all); Line 5014: FROM wf_item_attribute_values wf, wf_roles wfr 5010: 5011: CURSOR valid_users_cursor IS 5012: SELECT DISTINCT wf.text_value name, 5013: wfr.display_name 5014: FROM wf_item_attribute_values wf, wf_roles wfr 5015: WHERE wf.item_type LIKE 'AZ%' 5016: AND wf.text_value = wfr.name 5017: AND wf.name = 'AZW_IA_ROLE' 5018: ORDER BY 1; Line 5257: FROM wf_item_attribute_values wf, wf_roles wfr 5253: 5254: CURSOR valid_users_cursor IS 5255: SELECT DISTINCT wf.text_value user_name, 5256: wfr.display_name 5257: FROM wf_item_attribute_values wf, wf_roles wfr 5258: WHERE wf.item_type LIKE 'AZ%' 5259: AND wf.text_value = wfr.name 5260: AND wf.name = 'AZW_IA_ROLE' 5261: ORDER BY 1;