APPS.PSP_PSPENAWD_XMLP_PKG dependencies on PSP_REPORT_TEMPLATE_DETAILS

Line 8: PSP_REPORT_TEMPLATE_DETAILS

4: CURSOR C1(P_LOOKUP_CODE IN VARCHAR2,P_TEMPLATE_ID IN NUMBER) IS
5: SELECT
6: COUNT(1)
7: FROM
8: PSP_REPORT_TEMPLATE_DETAILS
9: WHERE TEMPLATE_ID = P_TEMPLATE_ID
10: AND CRITERIA_LOOKUP_TYPE = 'PSP_SELECTION_CRITERIA'
11: AND CRITERIA_LOOKUP_CODE = P_LOOKUP_CODE;
12: L_NUM NUMBER;

Line 23: P_AWARD_ID := ' and gaa.award_id IN (select criteria_value1 from psp_report_template_details

19: FETCH C1
20: INTO L_NUM;
21: CLOSE C1;
22: IF L_NUM <> 0 THEN
23: P_AWARD_ID := ' and gaa.award_id IN (select criteria_value1 from psp_report_template_details
24: where template_id = ' || P_AWD_TEMPLATE_ID || '
25: and criteria_lookup_type = ''PSP_SELECTION_CRITERIA''
26: and criteria_lookup_code = ''AWD'' ' || ' ) ';
27: ELSE

Line 39: P_PAYROLL_ID := ' and pelh.payroll_id IN (select criteria_value1 from psp_report_template_details

35: FETCH C1
36: INTO L_NUM2;
37: CLOSE C1;
38: IF L_NUM2 <> 0 THEN
39: P_PAYROLL_ID := ' and pelh.payroll_id IN (select criteria_value1 from psp_report_template_details
40: where template_id = ' || P_PAY_TEMPLATE_ID || '
41: and criteria_lookup_type = ''PSP_SELECTION_CRITERIA''
42: and criteria_lookup_code = ''PAY'' ' || ' ) ';
43: ELSE