DBA Data[Home] [Help]

APPS.PA_PROJ_ELEMENTS_UTILS dependencies on PA_WF_PROCESSES

Line 4922: FROM pa_wf_processes pwp, pa_proj_elements ppe -- Bug #3967939

4918: IS
4919: CURSOR C
4920: IS
4921: SELECT 'Y'
4922: FROM pa_wf_processes pwp, pa_proj_elements ppe -- Bug #3967939
4923: WHERE pwp.ENTITY_KEY2 = to_char(p_proj_element_id) -- Bug#3619754 : Added to_char
4924: AND ppe.PROJ_ELEMENT_ID = p_proj_element_id -- Bug #3967939
4925: AND pwp.ITEM_TYPE = ppe.WF_ITEM_TYPE; -- Bug #3967939
4926:

Line 4949: from pa_wf_processes wp

4945: IS
4946: CURSOR C
4947: IS
4948: select max(item_key)
4949: from pa_wf_processes wp
4950: , pa_proj_elements pe
4951: where wp.item_type = pe.wf_item_type
4952: and wp.wf_type_code = p_wf_type_code
4953: and to_char(pe.proj_element_id) = wp.entity_key2 --Bug 3619754 Added By avaithia