APPS.PSP_ROLLBACK_EFF_REPORTS dependencies on PSP_EFF_REPORTS

Line 17: from psp_eff_reports

13: l_parent_itemkey t_varchar2_240_type ;
14:
15: CURSOR effort_master_csr IS
16: select effort_report_id, person_id
17: from psp_eff_reports
18: WHERE request_id = p_request_id
19: AND nvl(p_person_id, person_id) = person_id ;
20:
21: CURSOR c_get_item_key (p_request_id NUMBER) is

Line 28: psp_eff_reports per

24: and ITEM_KEY in (
25: select pera.WF_ITEM_KEY --into l_itemkey
26: from psp_eff_Report_approvals pera,
27: psp_eff_report_details perd,
28: psp_eff_reports per
29: where pera.EFFORT_REPORT_DETAIL_ID = perd.EFFORT_REPORT_DETAIL_ID
30: and perd.EFFORT_REPORT_ID = per.EFFORT_REPORT_ID
31: and per.request_id = p_request_id );
32:

Line 35: FROM PSP_EFF_REPORTS per ,

31: and per.request_id = p_request_id );
32:
33: CURSOR c_get_approved_eff_rep(p_request_id NUMBER,P_PERSON_ID NUMBER) is
34: SELECT 1
35: FROM PSP_EFF_REPORTS per ,
36: PSP_REPORT_TEMPLATES_H PRTH
37: WHERE per.STATUS_CODE ='A'
38: AND per.request_id= p_request_id
39: and nvl(P_PERSON_ID ,per.person_id)= per.PERSON_ID

Line 66: SELECT 1 INTO l_appr_exists FROM PSP_EFF_REPORTS per WHERE per.STATUS_CODE ='A'

62: raise l_eff_report_approved;
63: end if;
64:
65: /*
66: SELECT 1 INTO l_appr_exists FROM PSP_EFF_REPORTS per WHERE per.STATUS_CODE ='A'
67: AND per.request_id= p_request_id and nvl(P_PERSON_ID ,per.person_id)= per.PERSON_ID
68: and rownum=1;
69:
70:

Line 156: Delete from psp_eff_reports where effort_report_id = eff_report_master_rec.effort_report_id(i);

152: = eff_report_master_rec.effort_report_id(i));
153:
154:
155: FORALL i in 1..eff_report_master_rec.effort_report_id.count
156: Delete from psp_eff_reports where effort_report_id = eff_report_master_rec.effort_report_id(i);
157:
158: /*
159:
160: FORALL i in 1.. eff_report_details_rec.effort_report_detail_id.count