APPS.HR_UTIL_MISC_SS dependencies on WF_ACTIVITIES

Line 412: WF_ACTIVITIES a1, WF_ACTIVITIES a2, WF_ACTIVITY_ATTR_VALUES aav

408:
409: CURSOR csr_wf_process (p_wfpname VARCHAR2, p_item_type VARCHAR2) IS
410: SELECT 'N' status
411: FROM WF_PROCESS_ACTIVITIES pa1, WF_PROCESS_ACTIVITIES pa2,
412: WF_ACTIVITIES a1, WF_ACTIVITIES a2, WF_ACTIVITY_ATTR_VALUES aav
413: WHERE pa1.process_item_type = p_item_type
414: and pa1.process_name = p_wfpname
415: and pa1.activity_name = pa2.process_name
416: and a1.name = pa1.process_name

Line 430: FROM WF_ACTIVITIES a, WF_PROCESS_ACTIVITIES pa,

426: and aav.name = 'HR_ACTIVITY_TYPE_VALUE'
427: and aav.text_value IN ('HR_TERMINATION_TOP_SS','HR_CWK_TERMINATION_PAGE_SS')
428: UNION
429: SELECT 'N' status
430: FROM WF_ACTIVITIES a, WF_PROCESS_ACTIVITIES pa,
431: WF_ACTIVITY_ATTR_VALUES aav
432: where a.item_type = p_item_type
433: and a.name = p_wfpname
434: and sysdate between a.begin_date and nvl(a.end_date,sysdate)

Line 639: FROM WF_ACTIVITIES a, WF_PROCESS_ACTIVITIES pa,

635: and me.function_id = p_func_id;
636:
637: CURSOR csr_wf_process (p_wfpname VARCHAR2, p_item_type VARCHAR2) IS
638: SELECT 'C' status
639: FROM WF_ACTIVITIES a, WF_PROCESS_ACTIVITIES pa,
640: WF_ACTIVITY_ATTR_VALUES aav
641: where a.item_type = p_item_type
642: and a.name = p_wfpname
643: and sysdate between a.begin_date and nvl(a.end_date,sysdate)