150: L_LOCATION_CODE VARCHAR2(60);
151: L_LOCATION_ID NUMBER(15);
152: L_BUFFER VARCHAR2(1000);
153: G_DELIMITER VARCHAR2(1) := ',';
154: G_EOL VARCHAR2(1) := FND_GLOBAL.LOCAL_CHR(10);
155: L_MAINTAIN_EST_EMP_COUNTS NUMBER(2);
156: temp boolean;
157: BEGIN
158: --HR_STANDARD.EVENT('BEFORE REPORT');
1356: ORDER BY
1357: LAST_NAME;
1358: L_BUFFER VARCHAR2(2000);
1359: G_DELIMITER VARCHAR2(1) := ',';
1360: G_EOL VARCHAR2(1) := FND_GLOBAL.LOCAL_CHR(10);
1361: BEGIN
1362: IF P_AUDIT_REPORT = 'Y' THEN
1363: -- Commented IF clause for bug#12575094
1364: --IF (CP_REPORT_TYPE = 'Establishment Report - Type 4' OR CP_REPORT_TYPE = 'Establishment Report - Type 9') AND CP_TOT_EMPS <= P_MINIMUM_NO_OF_EMPLOYEES THEN