APPS.PA_PROGRESS_REPORT_PVT dependencies on PA_PROJECT_STATUSES

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 1994: from wf_item_activity_statuses wias, pa_project_statuses pps

1990: CURSOR get_wf_status IS
1991: select 'Y' FROM dual
1992: WHERE exists
1993: (SELECT *
1994: from wf_item_activity_statuses wias, pa_project_statuses pps
1995: WHERE wias.item_type = pps.WORKFLOW_ITEM_TYPE
1996: AND wias.item_key = l_item_key
1997: AND wias.activity_status = 'ACTIVE'
1998: AND pps.status_type = 'PROGRESS_REPORT'

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'

Line 2223: from wf_item_activity_statuses wias, pa_project_statuses pps

2219: CURSOR get_wf_status IS
2220: select 'Y' FROM dual
2221: WHERE exists
2222: (SELECT *
2223: from wf_item_activity_statuses wias, pa_project_statuses pps
2224: WHERE wias.item_type = pps.WORKFLOW_ITEM_TYPE
2225: AND wias.item_key = l_item_key
2226: AND wias.activity_status = 'ACTIVE'
2227: AND pps.status_type = 'PROGRESS_REPORT'

Line 2747: workflow_process, enable_wf_flag from pa_project_statuses

2743: CURSOR get_wf_process_name
2744: IS
2745: select
2746: WORKFLOW_ITEM_TYPE,
2747: workflow_process, enable_wf_flag from pa_project_statuses
2748: where status_type = 'PROGRESS_REPORT'
2749: AND project_status_code = 'PROGRESS_REPORT_SUBMITTED';
2750:
2751: BEGIN

Line 2976: wf_failure_status_code from pa_project_statuses

2972:
2973: CURSOR get_wf_info is
2974: select enable_wf_flag, workflow_item_type,
2975: workflow_process,wf_success_status_code,
2976: wf_failure_status_code from pa_project_statuses
2977: where project_status_code = p_report_status;
2978:
2979:
2980: --like 'PROGRESS_REPORT%'