APPS.PSP_ER_AME dependencies on PSP_REPORT_TEMPLATES_H

Line 100: from psp_report_templates_h

96: select decode(approval_type,'PRE','N','Y') workflow_approval_req_flag,
97: approval_type,
98: custom_approval_code,
99: sup_levels
100: from psp_report_templates_h
101: where request_id = p_request_id;
102:
103: cursor check_valid_prj is
104: select er.person_id

Line 113: from psp_report_templates_h

109: and er.request_id = p_request_id;
110:
111: cursor get_report_layout is
112: select substr(report_Template_code,6,3)
113: from psp_report_templates_h
114: where request_id = p_request_id;
115:
116: l_report_layout_code varchar2(20);
117: l_err_person_id number;