APPS.PSP_PSPLDPRJ_XMLP_PKG dependencies on PSP_REPORT_TEMPLATE_DETAILS

Line 9: PSP_REPORT_TEMPLATE_DETAILS

5: CURSOR C1(P_LOOKUP_CODE IN VARCHAR2,P_TEMPLATE_ID IN NUMBER) IS
6: SELECT
7: COUNT(1)
8: FROM
9: PSP_REPORT_TEMPLATE_DETAILS
10: WHERE TEMPLATE_ID = P_TEMPLATE_ID
11: AND CRITERIA_LOOKUP_TYPE = 'PSP_SELECTION_CRITERIA'
12: AND CRITERIA_LOOKUP_CODE = P_LOOKUP_CODE;
13: L_NUM NUMBER;

Line 24: P_PROJECT_ID := ' and a.project_id IN (select criteria_value1 from psp_report_template_details

20: FETCH C1
21: INTO L_NUM;
22: CLOSE C1;
23: IF L_NUM <> 0 THEN
24: P_PROJECT_ID := ' and a.project_id IN (select criteria_value1 from psp_report_template_details
25: where template_id = ' || P_PRJ_TEMPLATE_ID || '
26: and criteria_lookup_type = ''PSP_SELECTION_CRITERIA''
27: and criteria_lookup_code = ''PRJ'' ' || ' ) ';
28: ELSE