APPS.HR_UTIL_MISC_SS dependencies on WF_ACTIVITIES

Line 420: WF_ACTIVITIES a1, WF_ACTIVITIES a2, WF_ACTIVITY_ATTR_VALUES aav

416:
417: CURSOR csr_wf_process (p_wfpname VARCHAR2, p_item_type VARCHAR2) IS
418: SELECT 'N' status
419: FROM WF_PROCESS_ACTIVITIES pa1, WF_PROCESS_ACTIVITIES pa2,
420: WF_ACTIVITIES a1, WF_ACTIVITIES a2, WF_ACTIVITY_ATTR_VALUES aav
421: WHERE pa1.process_item_type = p_item_type
422: and pa1.process_name = p_wfpname
423: and pa1.activity_name = pa2.process_name
424: and a1.name = pa1.process_name

Line 438: FROM WF_ACTIVITIES a, WF_PROCESS_ACTIVITIES pa,

434: and aav.name = 'HR_ACTIVITY_TYPE_VALUE'
435: and aav.text_value IN ('HR_TERMINATION_TOP_SS','HR_CWK_TERMINATION_PAGE_SS')
436: UNION
437: SELECT 'N' status
438: FROM WF_ACTIVITIES a, WF_PROCESS_ACTIVITIES pa,
439: WF_ACTIVITY_ATTR_VALUES aav
440: where a.item_type = p_item_type
441: and a.name = p_wfpname
442: and sysdate between a.begin_date and nvl(a.end_date,sysdate)

Line 647: FROM WF_ACTIVITIES a, WF_PROCESS_ACTIVITIES pa,

643: and me.function_id = p_func_id;
644:
645: CURSOR csr_wf_process (p_wfpname VARCHAR2, p_item_type VARCHAR2) IS
646: SELECT 'C' status
647: FROM WF_ACTIVITIES a, WF_PROCESS_ACTIVITIES pa,
648: WF_ACTIVITY_ATTR_VALUES aav
649: where a.item_type = p_item_type
650: and a.name = p_wfpname
651: and sysdate between a.begin_date and nvl(a.end_date,sysdate)