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 3847: ,p_process_name in wf_process_activities.process_name%type)

3843: -- |--------------------< wf_get_runnable_process_name >----------------------|
3844: -- ----------------------------------------------------------------------------
3845: function wf_get_runnable_process_name
3846: (p_item_type in wf_items.item_type%type
3847: ,p_process_name in wf_process_activities.process_name%type)
3848: return wf_runnable_processes_v.display_name%type is
3849: -- cursor determines is the specified process is runnable
3850: cursor csr_wrpv is
3851: select wrpv.display_name

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

3870: -- |-------------------------< wf_process_runnable >--------------------------|
3871: -- ----------------------------------------------------------------------------
3872: function wf_process_runnable
3873: (p_item_type in wf_items.item_type%type
3874: ,p_process_name in wf_process_activities.process_name%type)
3875: return boolean is
3876: --
3877: begin
3878: if wf_get_runnable_process_name