DBA Data[Home] [Help]

APPS.PA_PROJ_ELEMENTS_UTILS dependencies on PA_WF_PROCESSES

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

4824: IS
4825: CURSOR C
4826: IS
4827: SELECT 'Y'
4828: FROM pa_wf_processes pwp, pa_proj_elements ppe -- Bug #3967939
4829: WHERE pwp.ENTITY_KEY2 = to_char(p_proj_element_id) -- Bug#3619754 : Added to_char
4830: AND ppe.PROJ_ELEMENT_ID = p_proj_element_id -- Bug #3967939
4831: AND pwp.ITEM_TYPE = ppe.WF_ITEM_TYPE; -- Bug #3967939
4832:

Line 4855: from pa_wf_processes wp

4851: IS
4852: CURSOR C
4853: IS
4854: select max(item_key)
4855: from pa_wf_processes wp
4856: , pa_proj_elements pe
4857: where wp.item_type = pe.wf_item_type
4858: and wp.wf_type_code = p_wf_type_code
4859: and to_char(pe.proj_element_id) = wp.entity_key2 --Bug 3619754 Added By avaithia