DBA Data[Home] [Help]

APPS.PA_PROGRESS_REPORT_WORKFLOW dependencies on PA_WF_PROCESSES

Line 89: FROM pa_wf_processes, pa_progress_report_vers pprv

85:
86: CURSOR get_last_workflow_info
87: IS
88: SELECT MAX(item_key)
89: FROM pa_wf_processes, pa_progress_report_vers pprv
90: WHERE item_type = p_item_type
91: AND description = p_process_name
92: AND pprv.version_id = p_version_id
93: AND entity_key1 = pprv.object_id

Line 719: FROM pa_wf_processes

715:
716: CURSOR get_last_workflow_info
717: IS
718: SELECT MAX(item_key)
719: FROM pa_wf_processes
720: WHERE item_type = p_item_type
721: AND description = p_process_name
722: AND entity_key1 = l_project_id
723: AND wf_type_code = 'Progress Report'

Line 2359: select max(item_type), max(item_key) from pa_wf_processes,

2355: and ppp.object_type = pprv.object_type
2356: and trunc(sysdate) between papf.effective_START_DATE and nvl(papf.effective_END_DATE, sysdate+1);
2357:
2358: CURSOR get_wf_info is
2359: select max(item_type), max(item_key) from pa_wf_processes,
2360: pa_progress_report_vers pprv
2361: where wf_type_code = 'Progress Report'
2362: and entity_key2= document_id
2363: AND entity_key1 = pprv.object_id