APPS.PSP_GENERAL dependencies on PSP_EFF_REPORT_DETAILS

Line 2457: from psp_eff_report_details

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));
2459: l_person_id number;
2460: begin
2461: if txn_id like 'SEED-EMP%' or

Line 2676: psp_eff_report_details perd,

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
2680: AND perd.effort_report_id = per.effort_report_id;

Line 2777: psp_eff_report_details perd,

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
2781: AND per.STATUS_CODE = p_status_code

Line 2789: psp_eff_report_details perd,

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
2793: AND per.STATUS_CODE = p_status_code