DBA Data[Home] [Help]

APPS.PA_PROGRESS_REPORT_PVT dependencies on PA_WF_PROCESSES

Line 1970: from pa_wf_processes pwp, pa_project_statuses pps,

1966:
1967:
1968: CURSOR get_item_key IS
1969: SELECT MAX(pwp.item_key), max(pwp.item_type)
1970: from pa_wf_processes pwp, pa_project_statuses pps,
1971: pa_progress_report_vers pprv
1972: where pwp.item_type = pps.WORKFLOW_ITEM_TYPE
1973: and pps.status_type = 'PROGRESS_REPORT'
1974: and pps.project_status_code = 'PROGRESS_REPORT_SUBMITTED'

Line 2198: from pa_wf_processes pwp, pa_project_statuses pps,

2194:
2195:
2196: CURSOR get_item_key IS
2197: SELECT MAX(pwp.item_key), max(pwp.item_type)
2198: from pa_wf_processes pwp, pa_project_statuses pps,
2199: pa_progress_report_vers pprv
2200: where pwp.item_type = pps.WORKFLOW_ITEM_TYPE
2201: and pps.status_type = 'PROGRESS_REPORT'
2202: and pps.project_status_code = 'PROGRESS_REPORT_SUBMITTED'