APPS.PSP_GENERAL dependencies on PSP_EFF_REPORT_APPROVALS

Line 2677: psp_eff_report_approvals pera

2673: CURSOR get_emp_cur IS
2674: SELECT DISTINCT per.full_name
2675: FROM psp_eff_reports per,
2676: psp_eff_report_details perd,
2677: psp_eff_report_approvals pera
2678: WHERE pera.wf_item_key = p_wf_item_key
2679: AND pera.effort_report_detail_id = perd.effort_report_detail_id
2680: AND perd.effort_report_id = per.effort_report_id;
2681:

Line 2778: psp_eff_report_approvals pera

2774: Cursor Is_eff_Report_superseded_csr(p_status_code IN Varchar2, p_wf_itrm_key IN Number) IS
2775: select 'Y'
2776: from psp_eff_reports per,
2777: psp_eff_report_details perd,
2778: psp_eff_report_approvals pera
2779: where per.EFFORT_REPORT_ID = perd.EFFORT_REPORT_ID
2780: and perd.EFFORT_REPORT_DETAIL_ID = pera.EFFORT_REPORT_DETAIL_ID
2781: AND per.STATUS_CODE = p_status_code
2782: and WF_ITEM_KEY = p_wf_itrm_key;

Line 2790: psp_eff_report_approvals pera

2786: from psp_eff_reports per,
2787: (select person_id ,STATUS_CODE, per.Start_date,per.end_date,per.EFFORT_REPORT_ID
2788: from psp_eff_reports per,
2789: psp_eff_report_details perd,
2790: psp_eff_report_approvals pera
2791: where per.EFFORT_REPORT_ID = perd.EFFORT_REPORT_ID
2792: and perd.EFFORT_REPORT_DETAIL_ID = pera.EFFORT_REPORT_DETAIL_ID
2793: AND per.STATUS_CODE = p_status_code
2794: and pera.WF_ITEM_KEY = p_wf_itrm_key) temp