[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT eev1.screen_entry_value screen_entry_value
FROM per_all_assignments_f asg1
,per_all_assignments_f asg2
,per_all_people_f per
,pay_element_links_f el
,pay_element_types_f et
,pay_input_values_f iv1
,pay_element_entries_f ee
,pay_element_entry_values_f eev1
WHERE asg1.assignment_id = p_assignment_id
AND p_effective_date BETWEEN asg1.effective_start_date AND asg1.effective_end_date
AND p_effective_date BETWEEN asg2.effective_start_date AND asg2.effective_end_date
AND per.person_id = asg1.person_id
AND asg2.person_id = per.person_id
AND asg2.primary_flag = 'Y'
AND et.element_name = 'Tax Card'
AND et.legislation_code = 'DK'
AND iv1.element_type_id = et.element_type_id
AND iv1.name = p_input_value
AND el.business_group_id = per.business_group_id
AND el.element_type_id = et.element_type_id
AND ee.assignment_id = asg2.assignment_id
AND ee.element_link_id = el.element_link_id
AND eev1.element_entry_id = ee.element_entry_id
AND eev1.input_value_id = iv1.input_value_id
AND p_effective_date BETWEEN ee.effective_start_date AND ee.effective_end_date
AND p_effective_date BETWEEN eev1.effective_start_date AND eev1.effective_end_date;
SELECT ee.effective_start_date effective_start_date, ee.effective_end_date effective_end_date
FROM per_all_assignments_f asg
,per_all_people_f per
,pay_element_links_f el
,pay_element_types_f et
,pay_element_entries_f ee
WHERE asg.assignment_id = p_assignment_id
AND p_effective_date BETWEEN asg.effective_start_date AND asg.effective_end_date
AND et.element_name = 'Tax'
AND et.legislation_code = 'DK'
AND el.business_group_id = per.business_group_id
AND el.element_type_id = et.element_type_id
AND ee.assignment_id = asg.assignment_id
AND ee.element_link_id = el.element_link_id
AND p_effective_date BETWEEN ee.effective_start_date AND ee.effective_end_date;
SELECT hoi.org_information3 WORKING_HOURS
, hoi.org_information4 FREQ
FROM hr_organization_information hoi
WHERE hoi.org_information_context='DK_EMPLOYMENT_DEFAULTS'
AND hoi.organization_id = p_org_id ;
SELECT ee.effective_start_date effective_start_date, ee.effective_end_date effective_end_date
FROM per_all_assignments_f asg
,per_all_people_f per
,pay_element_links_f el
,pay_element_types_f et
,pay_element_entries_f ee
WHERE asg.assignment_id = p_assignment_id
AND p_effective_date BETWEEN asg.effective_start_date AND asg.effective_end_date
AND et.element_name = 'Employee ATP'
AND et.legislation_code = 'DK'
AND el.business_group_id = per.business_group_id
AND el.element_type_id = et.element_type_id
AND ee.assignment_id = asg.assignment_id
AND ee.element_link_id = el.element_link_id
AND p_effective_date BETWEEN ee.effective_start_date AND ee.effective_end_date;
SELECT hoi2.org_information1 cvr_number
FROM HR_ORGANIZATION_INFORMATION hoi1
,HR_ORGANIZATION_INFORMATION hoi2
,HR_ORGANIZATION_UNITS hou
,PAY_PAYROLL_ACTIONS ppa
WHERE ppa.payroll_action_id = p_payroll_action_id
and hoi1.org_information_context ='CLASS'
and hoi1.org_information1 ='DK_SERVICE_PROVIDER'
and hoi1.ORG_INFORMATION2 ='Y'
and hoi2.ORG_INFORMATION_CONTEXT= 'DK_SERVICE_PROVIDER_DETAILS'
and hoi2.organization_id = hoi1.organization_id
and hou.organization_id = hoi1.organization_id
and hou.business_group_id = ppa.BUSINESS_GROUP_ID
and ppa.EFFECTIVE_DATE BETWEEN hou.DATE_FROM and nvl(hou.DATE_TO, ppa.EFFECTIVE_DATE);
SELECT eev1.screen_entry_value atp_override_hours
FROM per_all_assignments_f asg1
,per_all_assignments_f asg2
,per_all_people_f per
,pay_element_links_f el
,pay_element_types_f et
,pay_input_values_f iv1
,pay_element_entries_f ee
,pay_element_entry_values_f eev1
WHERE asg1.assignment_id = p_assignment_id
AND p_effective_date BETWEEN asg1.effective_start_date AND asg1.effective_end_date
AND per.person_id = asg1.person_id
AND asg2.person_id = per.person_id
AND asg2.primary_flag = 'Y'
AND et.element_name = 'ATP Override Hours'
AND et.legislation_code = 'DK'
AND iv1.element_type_id = et.element_type_id
AND iv1.name = 'ATP Override Hours'
AND el.business_group_id = per.business_group_id
AND el.element_type_id = et.element_type_id
AND ee.assignment_id = asg2.assignment_id
AND ee.element_link_id = el.element_link_id
AND eev1.element_entry_id = ee.element_entry_id
AND eev1.input_value_id = iv1.input_value_id
AND p_effective_date BETWEEN ee.effective_start_date AND ee.effective_end_date
AND p_effective_date BETWEEN eev1.effective_start_date AND eev1.effective_end_date;
SELECT ee.element_entry_id element_entry_id
, eev1.screen_entry_value screen_entry_value
, iv1.name
FROM per_all_assignments_f asg1
,per_all_assignments_f asg2
,per_all_people_f per
,pay_element_links_f el
,pay_element_types_f et
,pay_input_values_f iv1
,pay_element_entries_f ee
,pay_element_entry_values_f eev1
WHERE asg1.assignment_id = p_assignment_id
AND p_effective_date BETWEEN asg1.effective_start_date AND asg1.effective_end_date
AND p_effective_date BETWEEN asg2.effective_start_date AND asg2.effective_end_date
AND per.person_id = asg1.person_id
AND asg2.person_id = per.person_id
AND et.element_name = 'Override Holiday Duration'
AND et.legislation_code = 'DK'
AND iv1.element_type_id = et.element_type_id
AND iv1.name in ('Start Date', 'End Date', 'Override Hours', 'Override Days')
AND el.business_group_id = per.business_group_id
AND el.element_type_id = et.element_type_id
AND ee.assignment_id = asg2.assignment_id
AND ee.element_link_id = el.element_link_id
AND eev1.element_entry_id = ee.element_entry_id
AND eev1.input_value_id = iv1.input_value_id
AND p_effective_date BETWEEN ee.effective_start_date AND ee.effective_end_date
AND p_effective_date BETWEEN eev1.effective_start_date AND eev1.effective_end_date
ORDER BY ee.element_entry_id;
SELECT tag
FROM fnd_lookup_values
WHERE lookup_type = 'FND_ISO_CHARACTER_SET_MAP'
AND lookup_code = SUBSTR(USERENV('LANGUAGE'),
INSTR(USERENV('LANGUAGE'), '.') + 1)
AND language = 'US';
SELECT paaf.hourly_salaried_code
FROM per_all_assignments_f paaf
WHERE paaf.assignment_id = p_assignment_id
AND p_effective_date BETWEEN paaf.effective_start_date AND paaf.effective_end_date;