APPS.PSP_ROLLBACK_EFF_REPORTS dependencies on PSP_REPORT_TEMPLATES_H

Line 36: PSP_REPORT_TEMPLATES_H PRTH

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
40: AND PER.REQUEST_ID = PRTH.REQUEST_ID