SQL_ID 7f569d5hcgzb4, child number 0 ------------------------------------- SELECT g.segment1 Entity, PER.EMPLOYEE_NUMBER Staff_ID, PER.FULL_NAME full_Name, ppd.segment2 POST, paf.ass_attribute1 Dept, xd.division_name Div, xs.division_name Sec, paat.NAME TYPE, TO_CHAR (paa.date_start, 'DD-MON-YYYY') start1, TO_CHAR (paa.date_end, 'DD-MON-YYYY') End1, paa.absence_days Days, paa.attribute10 Reason, TO_CHAR (paa.creation_date, 'DD-MON-YYYY') created_date, NVL ( xxmt.MT_LMS. get_annual_leaves_opn_bal (per.person_id, 'ANNUAL LEAVE', paa.date_start), 0) Ann_Bal, Absence_Attendance_Id Absence_Id FROM apps.PER_ALL_PEOPLE_F PER, apps.PER_ALL_ASSIGNMENTS_F PAF, xxmt_sections xs, xxmt_divisions xd, per_grades pg, apps.pay_people_groups g, per_grade_definitions pgd, per_positions pp, per_position_definit Plan hash value: 1958879867 ------------------------------------------------------------------------------------------------------------------------------------------------------ | Id | Operation | Name | E-Rows |E-Bytes| Cost (%CPU)| E-Time | OMem | 1Mem | Used-Mem | ------------------------------------------------------------------------------------------------------------------------------------------------------ | 0 | SELECT STATEMENT | | | | 64 (100)| | | | | | 1 | NESTED LOOPS OUTER | | 1 | 331 | 62 (2)| 00:00:01 | | | | | 2 | NESTED LOOPS | | 1 | 305 | 61 (2)| 00:00:01 | | | | | 3 | NESTED LOOPS | | 1 | 301 | 61 (2)| 00:00:01 | | | | |* 4 | HASH JOIN OUTER | | 1 | 292 | 60 (2)| 00:00:01 | 740K| 740K| 394K (0)| |* 5 | HASH JOIN OUTER | | 1 | 255 | 55 (2)| 00:00:01 | 743K| 743K| 380K (0)| | 6 | NESTED LOOPS | | | | | | | | | | 7 | NESTED LOOPS | | 1 | 218 | 49 (0)| 00:00:01 | | | | | 8 | NESTED LOOPS | | 1 | 193 | 48 (0)| 00:00:01 | | | | | 9 | NESTED LOOPS | | 1 | 143 | 12 (0)| 00:00:01 | | | | | 10 | NESTED LOOPS OUTER | | 1 | 133 | 11 (0)| 00:00:01 | | | | | 11 | NESTED LOOPS OUTER | | 1 | 129 | 10 (0)| 00:00:01 | | | | | 12 | NESTED LOOPS | | 1 | 112 | 8 (0)| 00:00:01 | | | | | 13 | NESTED LOOPS | | 1 | 57 | 6 (0)| 00:00:01 | | | | |* 14 | TABLE ACCESS BY INDEX ROWID| PER_ALL_PEOPLE_F | 1 | 48 | 4 (0)| 00:00:01 | | | | |* 15 | INDEX RANGE SCAN | PER_PEOPLE_F_N51 | 3 | | 1 (0)| 00:00:01 | | | | |* 16 | VIEW PUSHED PREDICATE | VW_SQ_1 | 1 | 9 | 2 (0)| 00:00:01 | | | | | 17 | SORT AGGREGATE | | 1 | 18 | | | | | | |* 18 | INDEX RANGE SCAN | PER_PEOPLE_F_PK | 2 | 36 | 2 (0)| 00:00:01 | | | | |* 19 | TABLE ACCESS BY INDEX ROWID | PER_ALL_ASSIGNMENTS_F | 1 | 55 | 2 (0)| 00:00:01 | | | | |* 20 | INDEX RANGE SCAN | PER_ASSIGNMENTS_F_N12 | 1 | | 1 (0)| 00:00:01 | | | | | 21 | SORT AGGREGATE | | 1 | 13 | | | | | | |* 22 | INDEX RANGE SCAN | PER_ASSIGNMENTS_F_N12 | 4 | 52 | 2 (0)| 00:00:01 | | | | | 23 | VIEW PUSHED PREDICATE | PER_POSITIONS | 1 | 17 | 2 (0)| 00:00:01 | | | | | 24 | NESTED LOOPS | | 1 | 22 | 2 (0)| 00:00:01 | | | | |* 25 | INDEX UNIQUE SCAN | HR_ALL_POSITIONS_F_TL_PK | 1 | 7 | 1 (0)| 00:00:01 | | | | |* 26 | TABLE ACCESS BY INDEX ROWID| PER_ALL_POSITIONS | 1 | 15 | 1 (0)| 00:00:01 | | | | |* 27 | INDEX UNIQUE SCAN | PER_POSITIONS_PK | 1 | | 0 (0)| | | | | | 28 | VIEW PUSHED PREDICATE | HR_LOCATIONS | 1 | 4 | 1 (0)| 00:00:01 | | | | | 29 | NESTED LOOPS | | 1 | 9 | 1 (0)| 00:00:01 | | | | |* 30 | INDEX UNIQUE SCAN | HR_LOCATIONS_ALL_TL_PK | 1 | 5 | 0 (0)| | | | | |* 31 | TABLE ACCESS BY INDEX ROWID | HR_LOCATIONS_ALL | 1 | 4 | 1 (0)| 00:00:01 | | | | |* 32 | INDEX UNIQUE SCAN | HR_LOCATIONS_PK | 1 | | 0 (0)| | | | | |* 33 | TABLE ACCESS BY INDEX ROWID | PAY_PEOPLE_GROUPS | 1 | 10 | 1 (0)| 00:00:01 | | | | |* 34 | INDEX UNIQUE SCAN | PAY_PEOPLE_GROUPS_PK | 1 | | 0 (0)| | | | | |* 35 | TABLE ACCESS BY INDEX ROWID | PER_ABSENCE_ATTENDANCES | 1 | 50 | 36 (0)| 00:00:01 | | | | |* 36 | INDEX RANGE SCAN | PER_ABSENCE_ATTENDANCES_N4 | 51 | | 1 (0)| 00:00:01 | | | | |* 37 | INDEX UNIQUE SCAN | PER_ABSENCE_ATTENDANCE_TYP_PK | 1 | | 0 (0)| | | | | | 38 | TABLE ACCESS BY INDEX ROWID | PER_ABSENCE_ATTENDANCE_TYPES | 1 | 25 | 1 (0)| 00:00:01 | | | | |* 39 | TABLE ACCESS FULL | HR_ALL_ORGANIZATION_UNITS | 85 | 3145 | 5 (0)| 00:00:01 | | | | |* 40 | TABLE ACCESS FULL | HR_ALL_ORGANIZATION_UNITS | 85 | 3145 | 5 (0)| 00:00:01 | | | | | 41 | TABLE ACCESS BY INDEX ROWID | PER_GRADES | 1 | 9 | 1 (0)| 00:00:01 | | | | |* 42 | INDEX UNIQUE SCAN | PER_GRADES_PK | 1 | | 0 (0)| | | | | |* 43 | INDEX UNIQUE SCAN | PER_GRADE_DEFINITIONS_PK | 1 | 4 | 0 (0)| | | | | | 44 | TABLE ACCESS BY INDEX ROWID | PER_POSITION_DEFINITIONS | 1 | 26 | 1 (0)| 00:00:01 | | | | |* 45 | INDEX UNIQUE SCAN | PER_POSITION_DEFINITIONS_PK | 1 | | 0 (0)| | | | | ------------------------------------------------------------------------------------------------------------------------------------------------------ Predicate Information (identified by operation id): --------------------------------------------------- 4 - access("PAF"."ASS_ATTRIBUTE3"=TO_CHAR("ORGANIZATION_ID")) 5 - access("PAF"."ASS_ATTRIBUTE2"=TO_CHAR("ORGANIZATION_ID")) 14 - filter((LOWER("HR_PERSON_TYPE_USAGE_INFO"."GET_USER_PERSON_TYPE"(SYSDATE@!,"PER"."PERSON_ID"))<>'ex-employee' AND LOWER("HR_PERSON_TYPE_USAGE_INFO"."GET_USER_PERSON_TYPE"(SYSDATE@!,"PER"."PERSON_ID"))<>'non-active employee' AND LOWER("HR_PERSON_TYPE_USAGE_INFO"."GET_USER_PERSON_TYPE"(SYSDATE@!,"PER"."PERSON_ID"))<>'contact' AND LOWER("HR_PERSON_TYPE_USAGE_INFO"."GET_USER_PERSON_TYPE"(SYSDATE@!,"PER"."PERSON_ID"))<>'pensioner' AND LOWER("HR_PERSON_TYPE_USAGE_INFO"."GET_USER_PERSON_TYPE"(SYSDATE@!,"PER"."PERSON_ID"))<>'retired' AND LOWER("HR_PERSON_TYPE_USAGE_INFO"."GET_USER_PERSON_TYPE"(SYSDATE@!,"PER"."PERSON_ID"))<>'resigned')) 15 - access("PER"."EMPLOYEE_NUMBER"='N0049') 16 - filter("PER"."EFFECTIVE_END_DATE"="MAX(PAPF.EFFECTIVE_END_DATE)") 18 - access("PAPF"."PERSON_ID"="PER"."PERSON_ID") 19 - filter(("PAF"."PEOPLE_GROUP_ID" IS NOT NULL AND "PAF"."GRADE_ID" IS NOT NULL)) 20 - access("PER"."PERSON_ID"="PAF"."PERSON_ID") filter("PAF"."EFFECTIVE_END_DATE"=) 22 - access("PAAF"."PERSON_ID"=:B1) 25 - access("PFT"."POSITION_ID"="PAF"."POSITION_ID" AND "PFT"."LANGUAGE"=USERENV('LANG')) 26 - filter("PAP"."BUSINESS_GROUP_ID"=DECODE("HR_GENERAL"."GET_XBG_PROFILE"(),'Y',"PAP"."BUSINESS_GROUP_ID","HR_GENERAL"."GET_BUSINESS_GROUP _ID"())) 27 - access("PAP"."POSITION_ID"="PAF"."POSITION_ID") filter(DECODE("HR_SECURITY"."VIEW_ALL"(),'Y','TRUE',"HR_SECURITY"."SHOW_RECORD"('PER_ALL_POSITIONS',"PAP"."POSITION_ID"))='TRUE') 30 - access("LOT"."LOCATION_ID"="PAF"."LOCATION_ID" AND "LOT"."LANGUAGE"=USERENV('LANG')) 31 - filter(NVL("LOC"."BUSINESS_GROUP_ID",NVL("HR_GENERAL"."GET_BUSINESS_GROUP_ID"(),(-99)))=NVL("HR_GENERAL"."GET_BUSINESS_GROUP_ID"(),NVL( "LOC"."BUSINESS_GROUP_ID",(-99)))) 32 - access("LOC"."LOCATION_ID"="PAF"."LOCATION_ID") 33 - filter(("G"."SEGMENT1" NOT LIKE 'MA%' AND "G"."SEGMENT1" NOT LIKE 'VT%')) 34 - access("PAF"."PEOPLE_GROUP_ID"="G"."PEOPLE_GROUP_ID") 35 - filter("PAA"."DATE_START">=TO_DATE(' 2018-01-01 00:00:00', 'syyyy-mm-dd hh24:mi:ss')) 36 - access("PAF"."PERSON_ID"="PAA"."PERSON_ID") 37 - access("PAA"."ABSENCE_ATTENDANCE_TYPE_ID"="PAAT"."ABSENCE_ATTENDANCE_TYPE_ID") 39 - filter(("TYPE"='DIVISION' AND NVL("DATE_TO",TO_DATE(' 4712-12-31 00:00:00', 'syyyy-mm-dd hh24:mi:ss'))=TO_DATE(' 4712-12-31 00:00:00', 'syyyy-mm-dd hh24:mi:ss'))) 40 - filter(("TYPE"='SECTION' AND NVL("DATE_TO",TO_DATE(' 4712-12-31 00:00:00', 'syyyy-mm-dd hh24:mi:ss'))=TO_DATE(' 4712-12-31 00:00:00', 'syyyy-mm-dd hh24:mi:ss'))) 42 - access("PAF"."GRADE_ID"="PG"."GRADE_ID") 43 - access("PG"."GRADE_DEFINITION_ID"="PGD"."GRADE_DEFINITION_ID") 45 - access("PP"."POSITION_DEFINITION_ID"="PPD"."POSITION_DEFINITION_ID") Note ----- - Warning: basic plan statistics not available. These are only collected when: * hint 'gather_plan_statistics' is used for the statement or * parameter 'statistics_level' is set to 'ALL', at session or system level SQL_ID 7f569d5hcgzb4, child number 1 ------------------------------------- SELECT g.segment1 Entity, PER.EMPLOYEE_NUMBER Staff_ID, PER.FULL_NAME full_Name, ppd.segment2 POST, paf.ass_attribute1 Dept, xd.division_name Div, xs.division_name Sec, paat.NAME TYPE, TO_CHAR (paa.date_start, 'DD-MON-YYYY') start1, TO_CHAR (paa.date_end, 'DD-MON-YYYY') End1, paa.absence_days Days, paa.attribute10 Reason, TO_CHAR (paa.creation_date, 'DD-MON-YYYY') created_date, NVL ( xxmt.MT_LMS. get_annual_leaves_opn_bal (per.person_id, 'ANNUAL LEAVE', paa.date_start), 0) Ann_Bal, Absence_Attendance_Id Absence_Id FROM apps.PER_ALL_PEOPLE_F PER, apps.PER_ALL_ASSIGNMENTS_F PAF, xxmt_sections xs, xxmt_divisions xd, per_grades pg, apps.pay_people_groups g, per_grade_definitions pgd, per_positions pp, per_position_definit Plan hash value: 1958879867 -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | Id | Operation | Name | Starts | E-Rows |E-Bytes| Cost (%CPU)| E-Time | A-Rows | A-Time | Buffers | Reads | OMem | 1Mem | Used-Mem | -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | 0 | SELECT STATEMENT | | 1 | | | 64 (100)| | 0 |00:00:00.01 | 83 | 2 | | | | | 1 | NESTED LOOPS OUTER | | 1 | 1 | 331 | 62 (2)| 00:00:01 | 0 |00:00:00.01 | 83 | 2 | | | | | 2 | NESTED LOOPS | | 1 | 1 | 305 | 61 (2)| 00:00:01 | 0 |00:00:00.01 | 83 | 2 | | | | | 3 | NESTED LOOPS | | 1 | 1 | 301 | 61 (2)| 00:00:01 | 0 |00:00:00.01 | 83 | 2 | | | | |* 4 | HASH JOIN OUTER | | 1 | 1 | 292 | 60 (2)| 00:00:01 | 0 |00:00:00.01 | 83 | 2 | 708K| 708K| 225K (0)| |* 5 | HASH JOIN OUTER | | 1 | 1 | 255 | 55 (2)| 00:00:01 | 0 |00:00:00.01 | 83 | 2 | 712K| 712K| 192K (0)| | 6 | NESTED LOOPS | | 1 | | | | | 0 |00:00:00.01 | 83 | 2 | | | | | 7 | NESTED LOOPS | | 1 | 1 | 218 | 49 (0)| 00:00:01 | 0 |00:00:00.01 | 83 | 2 | | | | | 8 | NESTED LOOPS | | 1 | 1 | 193 | 48 (0)| 00:00:01 | 0 |00:00:00.01 | 83 | 2 | | | | | 9 | NESTED LOOPS | | 1 | 1 | 143 | 12 (0)| 00:00:01 | 0 |00:00:00.01 | 83 | 2 | | | | | 10 | NESTED LOOPS OUTER | | 1 | 1 | 133 | 11 (0)| 00:00:01 | 0 |00:00:00.01 | 83 | 2 | | | | | 11 | NESTED LOOPS OUTER | | 1 | 1 | 129 | 10 (0)| 00:00:01 | 0 |00:00:00.01 | 83 | 2 | | | | | 12 | NESTED LOOPS | | 1 | 1 | 112 | 8 (0)| 00:00:01 | 0 |00:00:00.01 | 83 | 2 | | | | | 13 | NESTED LOOPS | | 1 | 1 | 57 | 6 (0)| 00:00:01 | 0 |00:00:00.01 | 83 | 2 | | | | |* 14 | TABLE ACCESS BY INDEX ROWID| PER_ALL_PEOPLE_F | 1 | 1 | 48 | 4 (0)| 00:00:01 | 0 |00:00:00.01 | 83 | 2 | | | | |* 15 | INDEX RANGE SCAN | PER_PEOPLE_F_N51 | 1 | 3 | | 1 (0)| 00:00:01 | 5 |00:00:00.01 | 2 | 0 | | | | |* 16 | VIEW PUSHED PREDICATE | VW_SQ_1 | 0 | 1 | 9 | 2 (0)| 00:00:01 | 0 |00:00:00.01 | 0 | 0 | | | | | 17 | SORT AGGREGATE | | 0 | 1 | 18 | | | 0 |00:00:00.01 | 0 | 0 | | | | |* 18 | INDEX RANGE SCAN | PER_PEOPLE_F_PK | 0 | 2 | 36 | 2 (0)| 00:00:01 | 0 |00:00:00.01 | 0 | 0 | | | | |* 19 | TABLE ACCESS BY INDEX ROWID | PER_ALL_ASSIGNMENTS_F | 0 | 1 | 55 | 2 (0)| 00:00:01 | 0 |00:00:00.01 | 0 | 0 | | | | |* 20 | INDEX RANGE SCAN | PER_ASSIGNMENTS_F_N12 | 0 | 1 | | 1 (0)| 00:00:01 | 0 |00:00:00.01 | 0 | 0 | | | | | 21 | SORT AGGREGATE | | 0 | 1 | 13 | | | 0 |00:00:00.01 | 0 | 0 | | | | |* 22 | INDEX RANGE SCAN | PER_ASSIGNMENTS_F_N12 | 0 | 4 | 52 | 2 (0)| 00:00:01 | 0 |00:00:00.01 | 0 | 0 | | | | | 23 | VIEW PUSHED PREDICATE | PER_POSITIONS | 0 | 1 | 17 | 2 (0)| 00:00:01 | 0 |00:00:00.01 | 0 | 0 | | | | | 24 | NESTED LOOPS | | 0 | 1 | 22 | 2 (0)| 00:00:01 | 0 |00:00:00.01 | 0 | 0 | | | | |* 25 | INDEX UNIQUE SCAN | HR_ALL_POSITIONS_F_TL_PK | 0 | 1 | 7 | 1 (0)| 00:00:01 | 0 |00:00:00.01 | 0 | 0 | | | | |* 26 | TABLE ACCESS BY INDEX ROWID| PER_ALL_POSITIONS | 0 | 1 | 15 | 1 (0)| 00:00:01 | 0 |00:00:00.01 | 0 | 0 | | | | |* 27 | INDEX UNIQUE SCAN | PER_POSITIONS_PK | 0 | 1 | | 0 (0)| | 0 |00:00:00.01 | 0 | 0 | | | | | 28 | VIEW PUSHED PREDICATE | HR_LOCATIONS | 0 | 1 | 4 | 1 (0)| 00:00:01 | 0 |00:00:00.01 | 0 | 0 | | | | | 29 | NESTED LOOPS | | 0 | 1 | 9 | 1 (0)| 00:00:01 | 0 |00:00:00.01 | 0 | 0 | | | | |* 30 | INDEX UNIQUE SCAN | HR_LOCATIONS_ALL_TL_PK | 0 | 1 | 5 | 0 (0)| | 0 |00:00:00.01 | 0 | 0 | | | | |* 31 | TABLE ACCESS BY INDEX ROWID | HR_LOCATIONS_ALL | 0 | 1 | 4 | 1 (0)| 00:00:01 | 0 |00:00:00.01 | 0 | 0 | | | | |* 32 | INDEX UNIQUE SCAN | HR_LOCATIONS_PK | 0 | 1 | | 0 (0)| | 0 |00:00:00.01 | 0 | 0 | | | | |* 33 | TABLE ACCESS BY INDEX ROWID | PAY_PEOPLE_GROUPS | 0 | 1 | 10 | 1 (0)| 00:00:01 | 0 |00:00:00.01 | 0 | 0 | | | | |* 34 | INDEX UNIQUE SCAN | PAY_PEOPLE_GROUPS_PK | 0 | 1 | | 0 (0)| | 0 |00:00:00.01 | 0 | 0 | | | | |* 35 | TABLE ACCESS BY INDEX ROWID | PER_ABSENCE_ATTENDANCES | 0 | 1 | 50 | 36 (0)| 00:00:01 | 0 |00:00:00.01 | 0 | 0 | | | | |* 36 | INDEX RANGE SCAN | PER_ABSENCE_ATTENDANCES_N4 | 0 | 51 | | 1 (0)| 00:00:01 | 0 |00:00:00.01 | 0 | 0 | | | | |* 37 | INDEX UNIQUE SCAN | PER_ABSENCE_ATTENDANCE_TYP_PK | 0 | 1 | | 0 (0)| | 0 |00:00:00.01 | 0 | 0 | | | | | 38 | TABLE ACCESS BY INDEX ROWID | PER_ABSENCE_ATTENDANCE_TYPES | 0 | 1 | 25 | 1 (0)| 00:00:01 | 0 |00:00:00.01 | 0 | 0 | | | | |* 39 | TABLE ACCESS FULL | HR_ALL_ORGANIZATION_UNITS | 0 | 85 | 3145 | 5 (0)| 00:00:01 | 0 |00:00:00.01 | 0 | 0 | | | | |* 40 | TABLE ACCESS FULL | HR_ALL_ORGANIZATION_UNITS | 0 | 85 | 3145 | 5 (0)| 00:00:01 | 0 |00:00:00.01 | 0 | 0 | | | | | 41 | TABLE ACCESS BY INDEX ROWID | PER_GRADES | 0 | 1 | 9 | 1 (0)| 00:00:01 | 0 |00:00:00.01 | 0 | 0 | | | | |* 42 | INDEX UNIQUE SCAN | PER_GRADES_PK | 0 | 1 | | 0 (0)| | 0 |00:00:00.01 | 0 | 0 | | | | |* 43 | INDEX UNIQUE SCAN | PER_GRADE_DEFINITIONS_PK | 0 | 1 | 4 | 0 (0)| | 0 |00:00:00.01 | 0 | 0 | | | | | 44 | TABLE ACCESS BY INDEX ROWID | PER_POSITION_DEFINITIONS | 0 | 1 | 26 | 1 (0)| 00:00:01 | 0 |00:00:00.01 | 0 | 0 | | | | |* 45 | INDEX UNIQUE SCAN | PER_POSITION_DEFINITIONS_PK | 0 | 1 | | 0 (0)| | 0 |00:00:00.01 | 0 | 0 | | | | -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Predicate Information (identified by operation id): --------------------------------------------------- 4 - access("PAF"."ASS_ATTRIBUTE3"=TO_CHAR("ORGANIZATION_ID")) 5 - access("PAF"."ASS_ATTRIBUTE2"=TO_CHAR("ORGANIZATION_ID")) 14 - filter((LOWER("HR_PERSON_TYPE_USAGE_INFO"."GET_USER_PERSON_TYPE"(SYSDATE@!,"PER"."PERSON_ID"))<>'ex-employee' AND LOWER("HR_PERSON_TYPE_USAGE_INFO"."GET_USER_PERSON_TYPE"(SYSDATE@!,"PER"."PERSON_ID"))<>'non-active employee' AND LOWER("HR_PERSON_TYPE_USAGE_INFO"."GET_USER_PERSON_TYPE"(SYSDATE@!,"PER"."PERSON_ID"))<>'contact' AND LOWER("HR_PERSON_TYPE_USAGE_INFO"."GET_USER_PERSON_TYPE"(SYSDATE@!,"PER"."PERSON_ID"))<>'pensioner' AND LOWER("HR_PERSON_TYPE_USAGE_INFO"."GET_USER_PERSON_TYPE"(SYSDATE@!,"PER"."PERSON_ID"))<>'retired' AND LOWER("HR_PERSON_TYPE_USAGE_INFO"."GET_USER_PERSON_TYPE"(SYSDATE@!,"PER"."PERSON_ID"))<>'resigned')) 15 - access("PER"."EMPLOYEE_NUMBER"='N0049') 16 - filter("PER"."EFFECTIVE_END_DATE"="MAX(PAPF.EFFECTIVE_END_DATE)") 18 - access("PAPF"."PERSON_ID"="PER"."PERSON_ID") 19 - filter(("PAF"."PEOPLE_GROUP_ID" IS NOT NULL AND "PAF"."GRADE_ID" IS NOT NULL)) 20 - access("PER"."PERSON_ID"="PAF"."PERSON_ID") filter("PAF"."EFFECTIVE_END_DATE"=) 22 - access("PAAF"."PERSON_ID"=:B1) 25 - access("PFT"."POSITION_ID"="PAF"."POSITION_ID" AND "PFT"."LANGUAGE"=USERENV('LANG')) 26 - filter("PAP"."BUSINESS_GROUP_ID"=DECODE("HR_GENERAL"."GET_XBG_PROFILE"(),'Y',"PAP"."BUSINESS_GROUP_ID","HR_GENERAL"."GET_BUSINESS_GROUP_ID"())) 27 - access("PAP"."POSITION_ID"="PAF"."POSITION_ID") filter(DECODE("HR_SECURITY"."VIEW_ALL"(),'Y','TRUE',"HR_SECURITY"."SHOW_RECORD"('PER_ALL_POSITIONS',"PAP"."POSITION_ID"))='TRUE') 30 - access("LOT"."LOCATION_ID"="PAF"."LOCATION_ID" AND "LOT"."LANGUAGE"=USERENV('LANG')) 31 - filter(NVL("LOC"."BUSINESS_GROUP_ID",NVL("HR_GENERAL"."GET_BUSINESS_GROUP_ID"(),(-99)))=NVL("HR_GENERAL"."GET_BUSINESS_GROUP_ID"(),NVL("LOC"."BUSINESS_GROUP_ID",(-99)))) 32 - access("LOC"."LOCATION_ID"="PAF"."LOCATION_ID") 33 - filter(("G"."SEGMENT1" NOT LIKE 'MA%' AND "G"."SEGMENT1" NOT LIKE 'VT%')) 34 - access("PAF"."PEOPLE_GROUP_ID"="G"."PEOPLE_GROUP_ID") 35 - filter("PAA"."DATE_START">=TO_DATE(' 2018-01-01 00:00:00', 'syyyy-mm-dd hh24:mi:ss')) 36 - access("PAF"."PERSON_ID"="PAA"."PERSON_ID") 37 - access("PAA"."ABSENCE_ATTENDANCE_TYPE_ID"="PAAT"."ABSENCE_ATTENDANCE_TYPE_ID") 39 - filter(("TYPE"='DIVISION' AND NVL("DATE_TO",TO_DATE(' 4712-12-31 00:00:00', 'syyyy-mm-dd hh24:mi:ss'))=TO_DATE(' 4712-12-31 00:00:00', 'syyyy-mm-dd hh24:mi:ss'))) 40 - filter(("TYPE"='SECTION' AND NVL("DATE_TO",TO_DATE(' 4712-12-31 00:00:00', 'syyyy-mm-dd hh24:mi:ss'))=TO_DATE(' 4712-12-31 00:00:00', 'syyyy-mm-dd hh24:mi:ss'))) 42 - access("PAF"."GRADE_ID"="PG"."GRADE_ID") 43 - access("PG"."GRADE_DEFINITION_ID"="PGD"."GRADE_DEFINITION_ID") 45 - access("PP"."POSITION_DEFINITION_ID"="PPD"."POSITION_DEFINITION_ID")