APPS.HR_APPROVAL_SS dependencies on WF_PROCESS_ACTIVITIES

Line 149: FROM WF_PROCESS_ACTIVITIES WPA,

145: and ias.item_key = p_item_key
146: and ias.activity_status = 'NOTIFIED'
147: and ias.process_activity in (
148: select wpa.instance_id
149: FROM WF_PROCESS_ACTIVITIES WPA,
150: WF_ACTIVITY_ATTRIBUTES WAA,
151: WF_ACTIVITIES WA,
152: WF_ITEMS WI
153: WHERE wpa.process_item_type = ias.item_type

Line 4874: ,p_process_name in wf_process_activities.process_name%type)

4870: -- |--------------------< wf_get_runnable_process_name >----------------------|
4871: -- ----------------------------------------------------------------------------
4872: function wf_get_runnable_process_name
4873: (p_item_type in wf_items.item_type%type
4874: ,p_process_name in wf_process_activities.process_name%type)
4875: return wf_runnable_processes_v.display_name%type is
4876: -- cursor determines is the specified process is runnable
4877: cursor csr_wrpv is
4878: select wrpv.display_name

Line 4901: ,p_process_name in wf_process_activities.process_name%type)

4897: -- |-------------------------< wf_process_runnable >--------------------------|
4898: -- ----------------------------------------------------------------------------
4899: function wf_process_runnable
4900: (p_item_type in wf_items.item_type%type
4901: ,p_process_name in wf_process_activities.process_name%type)
4902: return boolean is
4903: --
4904: begin
4905: if wf_get_runnable_process_name