APPS.PSP_PSPENCDU_XMLP_PKG dependencies on PSP_REPORT_TEMPLATE_DETAILS

Line 215: PSP_REPORT_TEMPLATE_DETAILS

211: CURSOR C1(P_LOOKUP_CODE IN VARCHAR2,L_TEMPLATE_ID IN NUMBER) IS
212: SELECT
213: COUNT(1)
214: FROM
215: PSP_REPORT_TEMPLATE_DETAILS
216: WHERE TEMPLATE_ID = L_TEMPLATE_ID
217: AND CRITERIA_LOOKUP_TYPE = 'PSP_SELECTION_CRITERIA'
218: AND CRITERIA_LOOKUP_CODE = P_LOOKUP_CODE;
219: L_NUM NUMBER;

Line 231: P_ORGANIZATIONS := ' and b.organization_id IN (select criteria_value1 from psp_report_template_details

227: FETCH C1
228: INTO L_NUM;
229: CLOSE C1;
230: IF L_NUM <> 0 THEN
231: P_ORGANIZATIONS := ' and b.organization_id IN (select criteria_value1 from psp_report_template_details
232: where template_id = ' || P_ORG_TEMPLATE_ID || '
233: and criteria_lookup_type = ''PSP_SELECTION_CRITERIA''
234: and criteria_lookup_code = ''ORG'' ' || ' ) ';
235: ELSE

Line 247: P_PAYROLL_ID := ' and a.payroll_id IN (select criteria_value1 from psp_report_template_details

243: FETCH C1
244: INTO L_NUM2;
245: CLOSE C1;
246: IF L_NUM2 <> 0 THEN
247: P_PAYROLL_ID := ' and a.payroll_id IN (select criteria_value1 from psp_report_template_details
248: where template_id = ' || P_PAY_TEMPLATE_ID || '
249: and criteria_lookup_type = ''PSP_SELECTION_CRITERIA''
250: and criteria_lookup_code = ''PAY'' ' || ' ) ';
251: ELSE