APPS.PSP_PSPLDSSA_XMLP_PKG dependencies on PSP_REPORT_TEMPLATE_DETAILS

Line 351: PSP_REPORT_TEMPLATE_DETAILS

347: CURSOR C1(P_LOOKUP_CODE IN VARCHAR2,P_TEMPLATE_ID IN NUMBER) IS
348: SELECT
349: COUNT(1)
350: FROM
351: PSP_REPORT_TEMPLATE_DETAILS
352: WHERE TEMPLATE_ID = P_TEMPLATE_ID
353: AND CRITERIA_LOOKUP_TYPE = 'PSP_SELECTION_CRITERIA'
354: AND CRITERIA_LOOKUP_CODE = P_LOOKUP_CODE;
355: L_NUM NUMBER;

Line 366: P_ORGANIZATION_ID := ' and a.organization_id IN (select criteria_value1 from psp_report_template_details

362: FETCH C1
363: INTO L_NUM;
364: CLOSE C1;
365: IF L_NUM <> 0 THEN
366: P_ORGANIZATION_ID := ' and a.organization_id IN (select criteria_value1 from psp_report_template_details
367: where template_id = ' || P_ORG_TEMPLATE_ID || '
368: and criteria_lookup_type = ''PSP_SELECTION_CRITERIA''
369: and criteria_lookup_code = ''ORG'' ' || ' ) ';
370: ELSE