APPS.PSP_CREATE_EFF_REPORTS dependencies on PSP_REPORT_TEMPLATE_DETAILS_H

Line 152: from psp_report_template_details_h where request_id = p_request_id and

148: l_template_id NUMBER;
149: i NUMBER;
150:
151: CURSOR get_summarization_criteria(p_request_id IN NUMBER) is Select criteria_lookup_code, criteria_value1
152: from psp_report_template_details_h where request_id = p_request_id and
153: criteria_lookup_type='PSP_SUMMARIZATION_CRITERIA' order by
154: to_number(criteria_value1);
155:
156:

Line 327: select criteria_value1 into l_element_set_id from psp_report_template_details_h where

323: -- fnd_file.put_line(fnd_file.log,' retry_Request_id = '||l_retry_request_id );
324: select parameter_value_2, parameter_value_3 into p_effort_start, p_effort_end from
325: psp_report_templates_h where request_id = l_request_id;
326:
327: select criteria_value1 into l_element_set_id from psp_report_template_details_h where
328: criteria_lookup_code='EST' and request_id = l_request_id;
329:
330:
331: /*