APPS.PSP_GENERAL dependencies on PSP_EFF_REPORTS

Line 2454: from psp_eff_reports

2450:
2451: function get_person_id(txn_id varchar2) return number is
2452: cursor get_person_id is
2453: select person_id
2454: from psp_eff_reports
2455: where effort_report_id in
2456: (select effort_report_id
2457: from psp_eff_report_details
2458: where effort_report_detail_id = substr(txn_id, 36,15));

Line 2646: SELECT distinct full_name FROM psp_eff_reports

2642: l_full_name VARCHAR2(50);
2643: i NUMBER := 0;
2644:
2645: CURSOR get_emp_cur IS
2646: SELECT distinct full_name FROM psp_eff_reports
2647: WHERE request_id = p_request_id;
2648:
2649: BEGIN
2650: l_emp_list := NULL;

Line 2675: FROM psp_eff_reports per,

2671:
2672: -- Modified cursor for Bug 7524262
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

Line 2776: from psp_eff_reports per,

2772: FUNCTION Is_eff_Report_status_changed (p_status_code IN Varchar2, p_wf_itrm_key IN Number)
2773: return varchar2 IS
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

Line 2786: from psp_eff_reports per,

2782: and WF_ITEM_KEY = p_wf_itrm_key;
2783:
2784: Cursor Is_new_eff_Report_created_csr(p_status_code IN Varchar2, p_wf_itrm_key IN Number) IS
2785: select 'Y'
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

Line 2788: from psp_eff_reports per,

2784: Cursor Is_new_eff_Report_created_csr(p_status_code IN Varchar2, p_wf_itrm_key IN Number) IS
2785: select 'Y'
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