APPS.PSP_PSPLSODR_XMLP_PKG dependencies on PSP_REPORT_TEMPLATE_DETAILS

Line 129: PSP_REPORT_TEMPLATE_DETAILS

125: CURSOR C_ORG_COUNT IS
126: SELECT
127: COUNT(1)
128: FROM
129: PSP_REPORT_TEMPLATE_DETAILS
130: WHERE TEMPLATE_ID = P_ORG_TEMPLATE_ID
131: AND CRITERIA_LOOKUP_TYPE = 'PSP_SELECTION_CRITERIA'
132: AND CRITERIA_LOOKUP_CODE = 'ORG';
133: CURSOR C_ORG_CURSOR IS

Line 137: PSP_REPORT_TEMPLATE_DETAILS

133: CURSOR C_ORG_CURSOR IS
134: SELECT
135: CRITERIA_VALUE1
136: FROM
137: PSP_REPORT_TEMPLATE_DETAILS
138: WHERE TEMPLATE_ID = P_ORG_TEMPLATE_ID
139: AND CRITERIA_LOOKUP_TYPE = 'PSP_SELECTION_CRITERIA'
140: AND CRITERIA_LOOKUP_CODE = 'ORG';
141: L_NUM NUMBER;

Line 203: PSP_REPORT_TEMPLATE_DETAILS

199: CURSOR C1(P_LOOKUP_CODE IN VARCHAR2,L_TEMPLATE_ID IN NUMBER) IS
200: SELECT
201: COUNT(1)
202: FROM
203: PSP_REPORT_TEMPLATE_DETAILS
204: WHERE TEMPLATE_ID = L_TEMPLATE_ID
205: AND CRITERIA_LOOKUP_TYPE = 'PSP_SELECTION_CRITERIA'
206: AND CRITERIA_LOOKUP_CODE = P_LOOKUP_CODE;
207: L_NUM NUMBER;

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

214: FETCH C1
215: INTO L_NUM;
216: CLOSE C1;
217: IF L_NUM <> 0 THEN
218: P_ORGANIZATION_ID := ' hou.organization_id IN (select criteria_value1 from psp_report_template_details
219: where template_id = ' || P_ORG_TEMPLATE_ID || '
220: and criteria_lookup_type = ''PSP_SELECTION_CRITERIA''
221: and criteria_lookup_code = ''ORG'' ' || ' ) ';
222: ELSE