[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT NVL(to_number(ucf.value),0)
FROM pay_user_column_instances_f ucf
,pay_user_columns uc
,pay_user_rows_f ur
,pay_user_tables ut
WHERE ut.legislation_code = 'NO'
AND ut.user_table_name = 'Sick Leave Monitoring'
AND ur.legislation_code = 'NO'
AND ur.user_table_id = ut.user_table_id
AND c_date BETWEEN ur.effective_start_date
AND ur.effective_end_date
AND ur.row_low_range_or_name = to_char(c_followup)
AND uc.legislation_code = 'NO'
AND uc.user_table_id = ut.user_table_id
AND uc.user_column_name = 'Max Days'
AND ucf.legislation_code = 'NO'
AND ucf.user_row_id = ur.user_row_id
AND ucf.user_column_id = uc.user_column_id
AND c_date BETWEEN ucf.effective_start_date
AND ucf.effective_end_date;
SELECT hou.name Name
,hou.business_group_id bg_id
FROM hr_organization_units hou
WHERE hou.organization_id = c_org_id;
SELECT ur.row_low_range_or_name followup
,max (decode (uc.user_column_name
,'Max Days'
,to_number(ucf.value)
,0)) days
,max (decode (uc.user_column_name
,'Action Message'
,ucf.value
,0)) message
FROM pay_user_column_instances_f ucf
,pay_user_columns uc
,pay_user_rows_f ur
,pay_user_tables ut
WHERE ut.legislation_code = 'NO'
AND ut.user_table_name = 'Sick Leave Monitoring'
AND ur.legislation_code = 'NO'
AND ur.user_table_id = ut.user_table_id
AND c_date BETWEEN ur.effective_start_date
AND ur.effective_end_date
AND uc.legislation_code = 'NO'
AND uc.user_table_id = ut.user_table_id
AND ucf.legislation_code = 'NO'
AND ucf.user_row_id = ur.user_row_id
AND ucf.user_column_id = uc.user_column_id
AND c_date BETWEEN ucf.effective_start_date
AND ucf.effective_end_date
GROUP BY ur.row_low_range_or_name
ORDER BY ur.row_low_range_or_name;
SELECT to_number (global_value)
FROM ff_globals_f
WHERE global_name = 'NO_ABS_LINK_PERIOD'
AND legislation_code = 'NO'
AND c_date BETWEEN effective_start_date
AND effective_end_date;
SELECT paa.absence_attendance_id abs_id
,paa.date_start start_date
,NVL(paa.date_end,c_to_date) end_date
,papf.employee_number employee_number
,papf.full_name employee_name
FROM per_absence_attendances paa
,per_absence_attendance_types paat
,per_all_assignments_f paaf
,per_assignment_status_types past
,per_all_people_f papf
,hr_soft_coding_keyflex hsc
,hr_organization_information hoi
WHERE paa.person_id = papf.person_id
AND paa.absence_attendance_type_id = paat.absence_attendance_type_id
AND paaf.person_id = papf.person_id
AND paaf.assignment_status_type_id = past.assignment_status_type_id
AND papf.business_group_id = c_bg_id
AND hsc.soft_coding_keyflex_id = paaf.soft_coding_keyflex_id
AND hoi.org_information1 = hsc.segment2
AND hoi.organization_id = c_org_id
AND past.per_system_status IN ('ACTIVE_ASSIGN','SUSP_ASSIGN')
AND hoi.org_information_context = 'NO_LOCAL_UNITS'
AND paaf.primary_flag = 'Y'
AND paat.absence_category IN ('S','PTS')
AND paa.date_start BETWEEN add_months(c_from_date,-24) --Last 2 years
AND c_to_date
AND paa.date_start BETWEEN papf.effective_start_date
AND papf.effective_end_date
AND paa.date_start BETWEEN paaf.effective_start_date
AND paaf.effective_end_date
ORDER BY paa.date_start DESC;
SELECT prev_abs.absence_attendance_id abs_id
,curr_abs.date_start - prev_abs.date_end duration
,prev_abs.date_start start_date
,curr_abs.date_start curr_start_date
,curr_abs.date_end curr_end_date
FROM per_absence_attendances prev_abs
,per_absence_attendances curr_abs
,per_absence_attendance_types pat
WHERE prev_abs.absence_attendance_type_id = pat.absence_attendance_type_id
AND prev_abs.date_end < curr_abs.date_start
AND pat.absence_category IN ('S','PTS')
AND (((curr_abs.date_start - prev_abs.date_end) <= absence_link_period)
OR (decode (trim (to_char (prev_abs.date_end,'DAY'))
,'FRIDAY',next_day (prev_abs.date_end,'SUNDAY')
,'SATURDAY',next_day (prev_abs.date_end,'SUNDAY')
,prev_abs.date_end) BETWEEN decode (trim (to_char (curr_abs.date_start,'DAY'))
,'MONDAY',curr_abs.date_start - 2
,'SUNDAY',curr_abs.date_start - 1
,curr_abs.date_start) - (absence_link_period+1)
AND decode (trim (to_char (curr_abs.date_start,'DAY'))
,'MONDAY',curr_abs.date_start - 2
,'SUNDAY',curr_abs.date_start - 1
,curr_abs.date_start)-1))
AND prev_abs.date_start IS NOT NULL
AND prev_abs.date_end IS NOT NULL
AND prev_abs.person_id = curr_abs.person_id
AND curr_abs.absence_attendance_id = c_abs_id
ORDER BY duration;
SELECT abs.date_start start_date
,NVL(abs.date_end,l_action_to) end_date
FROM per_absence_attendances abs
WHERE abs.absence_attendance_id = c_abs_id;
SELECT decode (c_followup
,1,org_information1
,2,org_information2
,3,org_information3
,4,org_information4
,5,org_information5
,9999) days
FROM hr_organization_information
WHERE organization_id = c_org_id
AND org_information_context = 'NO_SLM_OVERRIDE';
data.DELETE;
override.DELETE;
followup_days.DELETE;
actions.delete;