APPS.PSP_PSPLDDFA_XMLP_PKG dependencies on PSP_REPORT_TEMPLATE_DETAILS

Line 120: PSP_REPORT_TEMPLATE_DETAILS

116: CURSOR C1(P_LOOKUP_CODE IN VARCHAR2,P_TEMPLATE_ID IN NUMBER) IS
117: SELECT
118: COUNT(1)
119: FROM
120: PSP_REPORT_TEMPLATE_DETAILS
121: WHERE TEMPLATE_ID = P_TEMPLATE_ID
122: AND CRITERIA_LOOKUP_TYPE = 'PSP_SELECTION_CRITERIA'
123: AND CRITERIA_LOOKUP_CODE = P_LOOKUP_CODE;
124: L_NUM NUMBER;

Line 135: P_ORGANIZATION_ID := ' and organization_id IN (select criteria_value1 from psp_report_template_details

131: FETCH C1
132: INTO L_NUM;
133: CLOSE C1;
134: IF L_NUM <> 0 THEN
135: P_ORGANIZATION_ID := ' and organization_id IN (select criteria_value1 from psp_report_template_details
136: where template_id = ' || P_ORG_TEMPLATE_ID || '
137: and criteria_lookup_type = ''PSP_SELECTION_CRITERIA''
138: and criteria_lookup_code = ''ORG'' ' || ' ) ';
139: ELSE