DBA Data[Home] [Help]

APPS.PA_PROGRESS_REPORT_PVT dependencies on PA_WF_PROCESSES

Line 1971: from pa_wf_processes pwp, pa_project_statuses pps,

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

Line 2199: from pa_wf_processes pwp, pa_project_statuses pps,

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