APPS.PSP_PSPLSEMP_XMLP_PKG dependencies on PSP_REPORT_TEMPLATE_DETAILS

Line 235: PSP_REPORT_TEMPLATE_DETAILS

231: CURSOR C_ORG_COUNT IS
232: SELECT
233: COUNT(1)
234: FROM
235: PSP_REPORT_TEMPLATE_DETAILS
236: WHERE TEMPLATE_ID = P_ORG_TEMPLATE_ID
237: AND CRITERIA_LOOKUP_TYPE = 'PSP_SELECTION_CRITERIA'
238: AND CRITERIA_LOOKUP_CODE = 'ORG';
239: CURSOR C_ORG_CURSOR IS

Line 243: PSP_REPORT_TEMPLATE_DETAILS

239: CURSOR C_ORG_CURSOR IS
240: SELECT
241: CRITERIA_VALUE1
242: FROM
243: PSP_REPORT_TEMPLATE_DETAILS
244: WHERE TEMPLATE_ID = P_ORG_TEMPLATE_ID
245: AND CRITERIA_LOOKUP_TYPE = 'PSP_SELECTION_CRITERIA'
246: AND CRITERIA_LOOKUP_CODE = 'ORG';
247: L_NUM NUMBER;

Line 298: PSP_REPORT_TEMPLATE_DETAILS

294: CURSOR C1(P_LOOKUP_CODE IN VARCHAR2,L_TEMPLATE_ID IN NUMBER) IS
295: SELECT
296: COUNT(1)
297: FROM
298: PSP_REPORT_TEMPLATE_DETAILS
299: WHERE TEMPLATE_ID = L_TEMPLATE_ID
300: AND CRITERIA_LOOKUP_TYPE = 'PSP_SELECTION_CRITERIA'
301: AND CRITERIA_LOOKUP_CODE = P_LOOKUP_CODE;
302: L_NUM NUMBER;

Line 312: P_ORGANIZATION_ID := ' hou.organization_id IN (select criteria_value1 from psp_report_template_details

308: FETCH C1
309: INTO L_NUM;
310: CLOSE C1;
311: IF L_NUM <> 0 THEN
312: P_ORGANIZATION_ID := ' hou.organization_id IN (select criteria_value1 from psp_report_template_details
313: where template_id = ' || P_ORG_TEMPLATE_ID || '
314: and criteria_lookup_type = ''PSP_SELECTION_CRITERIA''
315: and criteria_lookup_code = ''ORG'' ' || ' ) ';
316: ELSE