APPS.PSP_PSPENCSC_XMLP_PKG dependencies on PSP_REPORT_TEMPLATE_DETAILS

Line 240: PSP_REPORT_TEMPLATE_DETAILS

236: CURSOR C1(P_LOOKUP_CODE IN VARCHAR2,L_TEMPLATE_ID IN NUMBER) IS
237: SELECT
238: COUNT(1)
239: FROM
240: PSP_REPORT_TEMPLATE_DETAILS
241: WHERE TEMPLATE_ID = L_TEMPLATE_ID
242: AND CRITERIA_LOOKUP_TYPE = 'PSP_SELECTION_CRITERIA'
243: AND CRITERIA_LOOKUP_CODE = P_LOOKUP_CODE;
244: L_NUM NUMBER;

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

252: FETCH C1
253: INTO L_NUM;
254: CLOSE C1;
255: IF L_NUM <> 0 THEN
256: P_ORGANIZATIONS := ' and b.organization_id IN (select criteria_value1 from psp_report_template_details
257: where template_id = ' || P_ORG_TEMPLATE_ID || '
258: and criteria_lookup_type = ''PSP_SELECTION_CRITERIA''
259: and criteria_lookup_code = ''ORG'' ' || ' ) ';
260: ELSE

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

268: FETCH C1
269: INTO L_NUM2;
270: CLOSE C1;
271: IF L_NUM2 <> 0 THEN
272: P_PAYROLL_ID := ' and a.payroll_id IN (select criteria_value1 from psp_report_template_details
273: where template_id = ' || P_PAY_TEMPLATE_ID || '
274: and criteria_lookup_type = ''PSP_SELECTION_CRITERIA''
275: and criteria_lookup_code = ''PAY'' ' || ' ) ';
276: ELSE