[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT action_information3 legal_employer_id, action_information4 legal_employer_name,
action_information5
org_number, fnd_number.canonical_to_number (action_information6) week_hours,
fnd_number.canonical_to_number (action_information7)
daily_hours,
fnd_number.canonical_to_number (action_information8) days_per_year,
fnd_number.canonical_to_number (action_information9)
hours_per_year,
fnd_date.canonical_to_date (action_information10) start_date,
fnd_date.canonical_to_date (action_information11)
end_date
FROM pay_action_information
WHERE action_context_type = 'PA'
AND action_context_id = csr_v_pa_id
AND action_information_category = 'EMEA REPORT INFORMATION'
AND action_information1 = 'PYSESLSA'
AND action_information3 = nvl (p_leagal_employer_id, action_information3)
AND action_information2 = p_curr_prev_std_hour;
SELECT action_information3 legal_employer_id, action_information4 legal_employer_name,
action_information5
org_number, fnd_number.canonical_to_number (action_information6) week_hours,
fnd_number.canonical_to_number (action_information7)
daily_hours,
fnd_number.canonical_to_number (action_information8) days_per_year,
fnd_number.canonical_to_number (action_information9)
hours_per_year,
fnd_date.canonical_to_date (action_information10) start_date,
fnd_date.canonical_to_date (action_information11)
end_date
FROM pay_action_information
WHERE action_context_type = 'PA'
AND action_context_id = csr_v_pa_id
AND action_information_category = 'EMEA REPORT INFORMATION'
AND action_information1 = 'PYSESLSA'
AND action_information3 = nvl (p_leagal_employer_id, action_information3)
AND action_information2 = p_curr_prev_std_hour;
SELECT fnd_number.canonical_to_number (action_information6) men_lower_age_count,
fnd_number.canonical_to_number (action_information7)
men_middle_age_count,
fnd_number.canonical_to_number (action_information8) men_upper_age_count,
fnd_number.canonical_to_number (action_information9)
women_lower_age_count,
fnd_number.canonical_to_number (action_information10) women_middle_age_count,
fnd_number.canonical_to_number (action_information11)
women_upper_age_count,
fnd_number.canonical_to_number (action_information12) men_lower_age_work_hour,
fnd_number.canonical_to_number (action_information13)
men_middle_age_work_hour,
fnd_number.canonical_to_number (action_information14) men_upper_age_work_hour,
fnd_number.canonical_to_number (action_information15)
women_lower_age_work_hour,
fnd_number.canonical_to_number (action_information16)
women_middle_age_work_hour,
fnd_number.canonical_to_number (action_information17)
women_upper_age_work_hour,
fnd_number.canonical_to_number (action_information18) men_l_age_sick_leaves,
fnd_number.canonical_to_number (action_information19)
men_m_age_sick_leaves,
fnd_number.canonical_to_number (action_information20) men_u_age_sick_leaves,
fnd_number.canonical_to_number (action_information21)
women_l_age_sick_leaves,
fnd_number.canonical_to_number (action_information22) women_m_age_sick_leaves,
fnd_number.canonical_to_number (action_information23)
women_u_age_sick_leaves,
fnd_number.canonical_to_number (action_information24) men_l_age_l_sick_leaves,
fnd_number.canonical_to_number (action_information25)
men_m_age_l_sick_leaves,
fnd_number.canonical_to_number (action_information26) men_u_age_l_sick_leaves,
fnd_number.canonical_to_number (action_information27)
women_l_age_l_sick_leaves,
fnd_number.canonical_to_number (action_information28)
women_m_age_l_sick_leaves,
fnd_number.canonical_to_number (action_information29)
women_u_age_l_sick_leaves
FROM pay_action_information
WHERE action_context_type = 'PA'
AND action_context_id = csr_v_pa_id
AND action_information_category = 'EMEA REPORT INFORMATION'
AND action_information1 = 'PYSESLSA'
AND action_information3 = p_leagal_employer_id
AND action_information2 = p_curr_prev_data;
SELECT fnd_number.canonical_to_number (action_information6) leave_to_work_hours,
fnd_number.canonical_to_number (action_information7)
long_leave_part,
fnd_number.canonical_to_number (action_information8) men_leave_to_work_hour,
fnd_number.canonical_to_number (action_information9)
women_leave_to_work_hour,
fnd_number.canonical_to_number (action_information10) leave_to_work_hour_lower,
fnd_number.canonical_to_number (action_information11)
leave_to_work_hour_middle,
fnd_number.canonical_to_number (action_information12) leave_to_work_hour_upper
FROM pay_action_information
WHERE action_context_type = 'PA'
AND action_context_id = csr_v_pa_id
AND action_information_category = 'EMEA REPORT INFORMATION'
AND action_information1 = 'PYSESLSA'
AND action_information3 = p_leagal_employer_id
AND action_information2 = p_curr_prev_stat;*/
SELECT fnd_number.canonical_to_number (action_information6) leave_to_work_hours,
fnd_number.canonical_to_number (action_information7)
long_leave_part,
fnd_number.canonical_to_number (action_information8) men_leave_to_work_hour,
fnd_number.canonical_to_number (action_information9)
women_leave_to_work_hour,
fnd_number.canonical_to_number (action_information10) leave_to_work_hour_lower,
fnd_number.canonical_to_number (action_information11)
leave_to_work_hour_middle,
fnd_number.canonical_to_number (action_information12) leave_to_work_hour_upper
FROM pay_action_information
WHERE action_context_type = 'PA'
AND action_context_id = csr_v_pa_id
AND action_information_category = 'EMEA REPORT INFORMATION'
AND action_information1 = 'PYSESLSA'
AND action_information3 = p_leagal_employer_id
AND action_information2 = p_curr_prev_stat;
SELECT payroll_action_id
INTO l_payroll_action_id
FROM pay_payroll_actions ppa, fnd_conc_req_summary_v fcrs, fnd_conc_req_summary_v fcrs1
WHERE fcrs.request_id = fnd_global.conc_request_id
AND fcrs.priority_request_id = fcrs1.priority_request_id
AND ppa.request_id BETWEEN fcrs1.request_id AND fcrs.request_id
AND ppa.request_id = fcrs1.request_id;