13: L_LOCATION_CODE VARCHAR2(60);
14: L_LOCATION_ID NUMBER(15);
15: L_BUFFER VARCHAR2(1000);
16: G_DELIMITER VARCHAR2(1) := ',';
17: G_EOL VARCHAR2(1) := FND_GLOBAL.LOCAL_CHR(10);
18: temp boolean;
19: BEGIN
20: --HR_STANDARD.EVENT('BEFORE REPORT');
21: temp := P_REPORT_YEARVALIDTRIGGER;
914: ORDER BY
915: LAST_NAME;
916: L_BUFFER VARCHAR2(2000);
917: G_DELIMITER VARCHAR2(1) := ',';
918: G_EOL VARCHAR2(1) := FND_GLOBAL.LOCAL_CHR(10);
919: BEGIN
920: IF P_AUDIT_REPORT = 'Y' THEN
921: 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
922: RETURN NULL;