[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
AND p_effective_date BETWEEN per.effective_start_date AND per.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;
SELECT value
FROM
nls_database_parameters
WHERE parameter='NLS_CHARACTERSET';
SELECT MIN(paaf.effective_start_date) effective_start_date
FROM per_all_assignments_f paaf
WHERE paaf.business_group_id = p_business_group_id
AND paaf.assignment_id = p_assignment_id
;
select count(distinct element_entry_id) from
pay_element_entries_f peef
where
peef.element_type_id = p_element_type_id
and peef.assignment_id = p_assignment_id
AND p_effective_date BETWEEN peef.effective_start_date AND peef.effective_end_date;
select distinct element_entry_id from
pay_element_entries_f peef
where
peef.element_type_id = p_element_type_id
and peef.assignment_id = p_assignment_id
AND p_effective_date BETWEEN peef.effective_start_date AND peef.effective_end_date;
SELECT fnd_number.canonical_to_number(NVL(peevf.screen_entry_value,'0')) Employee_Amount,
fnd_number.canonical_to_number(NVL(peevf1.screen_entry_value,'0')) Employer_Amount,
fnd_number.canonical_to_number(NVL(peevf2.screen_entry_value,'0')) Employee_Percent,
fnd_number.canonical_to_number(NVL(peevf3.screen_entry_value,'0')) Employer_Percent
from
pay_element_entry_values_f peevf,
pay_element_entry_values_f peevf1,
pay_element_entry_values_f peevf2,
pay_element_entry_values_f peevf3,
pay_input_values_f piv_ee_amt,
pay_input_values_f piv_er_amt,
pay_input_values_f piv_ee_perc,
pay_input_values_f piv_er_perc
where peevf.element_entry_id = p_element_entry_id
AND p_effective_date BETWEEN peevf.effective_start_date AND peevf.effective_end_date
AND piv_ee_amt.element_type_id = p_element_type_id
AND piv_ee_amt.input_value_id = peevf.input_value_id
AND piv_ee_amt.name = 'Employee Fixed Amount'
AND p_effective_date BETWEEN piv_ee_amt.effective_start_date AND piv_ee_amt.effective_end_date
AND peevf1.element_entry_id = p_element_entry_id
AND p_effective_date BETWEEN peevf1.effective_start_date AND peevf1.effective_end_date
AND piv_er_amt.element_type_id = p_element_type_id
AND piv_er_amt.input_value_id = peevf1.input_value_id
AND piv_er_amt.name = 'Employer Fixed Amount'
AND p_effective_date BETWEEN piv_er_amt.effective_start_date AND piv_er_amt.effective_end_date
AND peevf2.element_entry_id = p_element_entry_id
AND p_effective_date BETWEEN peevf2.effective_start_date AND peevf2.effective_end_date
AND piv_ee_perc.element_type_id = p_element_type_id
AND piv_ee_perc.input_value_id = peevf2.input_value_id
AND piv_ee_perc.name = 'Employee Percentage'
AND p_effective_date BETWEEN piv_ee_perc.effective_start_date AND piv_ee_perc.effective_end_date
AND peevf3.element_entry_id = p_element_entry_id
AND p_effective_date BETWEEN peevf3.effective_start_date AND peevf3.effective_end_date
AND piv_er_perc.element_type_id = p_element_type_id
AND piv_er_perc.input_value_id = peevf3.input_value_id
AND piv_er_perc.name = 'Employer Percentage'
AND p_effective_date BETWEEN piv_er_perc.effective_start_date AND piv_er_perc.effective_end_date;
SELECT 'Y'
FROM pay_payroll_actions ppa
, pay_user_tables put
, pay_user_columns puc
, pay_user_column_instances_f puci
, pay_user_rows_f pur
, pay_user_columns puc1
, pay_user_column_instances_f puci1
, pay_user_rows_f pur1
WHERE ppa.payroll_action_id = p_payroll_action_id
AND put.user_table_name = 'DK_PBS_DATA'
AND put.LEGISLATION_CODE ='DK'
AND puc.user_table_id = put.user_table_id
AND puc.user_column_name = 'Information Type'
AND puci.user_column_id = puc.user_column_id
AND ppa.effective_date between puci.effective_start_date and puci.effective_end_date
AND pur.user_row_id = puci.user_row_id
AND ppa.effective_date between pur.effective_start_date and pur.effective_end_date
and puc1.user_table_id = put.user_table_id
and puc1.user_column_name = 'PBS Number'
and puci1.user_column_id = puc1.user_column_id
and puci1.business_group_id =ppa.business_group_id
and ppa.effective_date between puci1.effective_start_date and puci1.effective_end_date
and pur1.user_row_id = puci1.user_row_id
and pur1.user_row_id = pur.user_row_id
and ppa.effective_date between pur1.effective_start_date and pur1.effective_end_date
and puci.value = '400';