[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT ptpt.number_per_fiscal_year
FROM per_all_assignments_f paaf, pay_all_payrolls_f pap, per_time_period_types ptpt, fnd_sessions fs
WHERE fs.session_id = userenv('sessionid')
AND paaf.assignment_id = p_assignment_id
AND fs.effective_date BETWEEN paaf.effective_start_date AND paaf.effective_end_Date
AND pap.payroll_id = paaf.payroll_id
AND fs.effective_date BETWEEN pap.effective_start_date AND pap.effective_end_Date
AND pap.period_type = ptpt.period_type;
SELECT nvl(min(peev.screen_entry_value), 'NP')
FROM fnd_sessions fs,
pay_element_types_f pet,
pay_input_values_f piv,
pay_element_entries_f peef,
pay_element_entry_values_f peev
WHERE fs.session_id = userenv('sessionid')
AND pet.element_name = 'NI'
AND pet.business_group_id IS NULL
AND pet.legislation_code = 'GB'
AND fs.effective_date BETWEEN pet.effective_start_date AND pet.effective_end_date
AND pet.element_type_id = piv.element_type_id
AND piv.name = 'Process Type'
AND piv.business_group_id IS NULL
AND piv.legislation_code = 'GB'
AND fs.effective_date BETWEEN piv.effective_start_date AND piv.effective_end_date
AND peef.assignment_id = p_assignment_id
AND fs.effective_date BETWEEN peef.effective_start_date AND peef.effective_end_date
AND peef.element_entry_id = peev.element_entry_id
AND peev.input_value_id = piv.input_value_id
AND fs.effective_date BETWEEN peev.effective_start_date AND peev.effective_end_date;
SELECT scl.segment1
FROM hr_soft_coding_keyflex scl,
fnd_sessions fs,
pay_payrolls_f ppf,
per_all_assignments_f paaf
WHERE paaf.assignment_id = p_assignment_id
AND fs.session_id = userenv('sessionid')
AND fs.effective_date BETWEEN paaf.effective_start_date AND paaf.effective_end_date
AND ppf.payroll_id = paaf.payroll_id
AND fs.effective_date BETWEEN ppf.effective_start_date AND ppf.effective_end_Date
AND ppf.soft_coding_keyflex_id = scl.soft_coding_keyflex_id;
SELECT piv.input_value_id
FROM fnd_sessions fs,
pay_element_types_f pet,
pay_input_values_f piv
WHERE fs.session_id = userenv('sessionid')
AND pet.element_name = p_ele_name
AND pet.business_group_id IS NULL
AND pet.legislation_code = 'GB'
AND fs.effective_date BETWEEN pet.effective_start_date AND pet.effective_end_date
AND pet.element_type_id = piv.element_type_id
AND piv.name = 'Main Entry'
AND piv.business_group_id IS NULL
AND piv.legislation_code = 'GB'
AND fs.effective_date BETWEEN piv.effective_start_date AND piv.effective_end_date;
SELECT count(*) cnt
FROM fnd_sessions fs,
per_all_assignments_f paaf1,
per_all_assignments_f paaf2,
pay_all_payrolls_f ppf,
hr_soft_coding_keyflex scl,
pay_element_entries_f peef,
pay_element_entry_values_f peev
WHERE paaf1.assignment_id = p_assignment_id
AND fs.session_id = userenv('sessionid')
AND fs.effective_date BETWEEN paaf1.effective_start_date AND paaf1.effective_end_date
AND paaf1.person_id = paaf2.person_id
AND fs.effective_date BETWEEN paaf2.effective_start_date AND paaf2.effective_end_date
AND paaf2.payroll_id = ppf.payroll_id
AND fs.effective_date BETWEEN ppf.effective_start_date AND ppf.effective_end_date
AND ppf.soft_coding_keyflex_id = scl.soft_coding_keyflex_id
AND scl.segment1 = p_asg_tax_ref
AND paaf2.assignment_id = peef.assignment_id
AND fs.effective_date BETWEEN peef.effective_start_date AND peef.effective_end_date
AND peef.element_entry_id = peev.element_entry_id
AND fs.effective_date BETWEEN peev.effective_start_date AND peev.effective_end_date
AND peev.input_value_id IN (g_eas_main_iv_id, g_eas_ntpp_main_iv_id)
AND nvl(SCREEN_ENTRY_VALUE, 'N') = 'Y';
SELECT 1 cnt
FROM fnd_sessions fs,
per_all_assignments_f paaf1,
per_all_assignments_f paaf2,
pay_all_payrolls_f ppf,
hr_soft_coding_keyflex scl,
pay_element_entries_f peef,
pay_element_entry_values_f peev
WHERE paaf1.assignment_id = p_assignment_id
AND fs.session_id = userenv('sessionid')
AND fs.effective_date BETWEEN paaf1.effective_start_date AND paaf1.effective_end_date
AND paaf1.person_id = paaf2.person_id
AND nvl(paaf2.primary_flag, 'N') = 'Y'
AND fs.effective_date BETWEEN paaf2.effective_start_date AND paaf2.effective_end_date
AND paaf2.payroll_id = ppf.payroll_id
AND fs.effective_date BETWEEN ppf.effective_start_date AND ppf.effective_end_date
AND ppf.soft_coding_keyflex_id = scl.soft_coding_keyflex_id
AND scl.segment1 = p_asg_tax_ref
AND paaf2.assignment_id = peef.assignment_id
AND fs.effective_date BETWEEN peef.effective_start_date AND peef.effective_end_date
AND peef.element_entry_id = peev.element_entry_id
AND fs.effective_date BETWEEN peev.effective_start_date AND peev.effective_end_date
AND peev.input_value_id IN (g_eas_main_iv_id, g_eas_ntpp_main_iv_id);
SELECT scl.segment1, ppf.payroll_id
FROM hr_soft_coding_keyflex scl,
fnd_sessions fs,
pay_payrolls_f ppf,
per_all_assignments_f paaf
WHERE paaf.assignment_id = p_assignment_id
AND fs.session_id = userenv('sessionid')
AND fs.effective_date BETWEEN paaf.effective_start_date AND paaf.effective_end_date
AND ppf.payroll_id = paaf.payroll_id
AND fs.effective_date BETWEEN ppf.effective_start_date AND ppf.effective_end_Date
AND ppf.soft_coding_keyflex_id = scl.soft_coding_keyflex_id;
SELECT ptp.start_date
FROM per_time_periods ptp, fnd_sessions fs
WHERE fs.session_id = userenv('sessionid')
AND ptp.payroll_id = l_asg_payroll_id
AND fs.effective_date = ptp.regular_payment_date;
SELECT ppf.payroll_id
FROM fnd_sessions fs,
per_all_assignments_f paaf1,
per_all_assignments_f paaf2,
pay_all_payrolls_f ppf,
hr_soft_coding_keyflex scl,
pay_element_entries_f peef,
pay_element_entry_values_f peev
WHERE paaf1.assignment_id = p_assignment_id
AND fs.session_id = userenv('sessionid')
AND fs.effective_date BETWEEN paaf1.effective_start_date AND paaf1.effective_end_date
AND paaf1.person_id = paaf2.person_id
AND fs.effective_date BETWEEN paaf2.effective_start_date AND paaf2.effective_end_date
AND paaf2.payroll_id = ppf.payroll_id
AND fs.effective_date BETWEEN ppf.effective_start_date AND ppf.effective_end_date
AND ppf.soft_coding_keyflex_id = scl.soft_coding_keyflex_id
AND scl.segment1 = l_asg_tax_ref
AND paaf2.assignment_id = peef.assignment_id
AND fs.effective_date BETWEEN peef.effective_start_date AND peef.effective_end_date
AND peef.element_entry_id = peev.element_entry_id
AND fs.effective_date BETWEEN peev.effective_start_date AND peev.effective_end_date
AND peev.input_value_id IN (g_eas_main_iv_id, g_eas_ntpp_main_iv_id)
AND nvl(SCREEN_ENTRY_VALUE, 'N') = 'Y';
SELECT ppf.payroll_id
FROM fnd_sessions fs,
per_all_assignments_f paaf1,
per_all_assignments_f paaf2,
pay_all_payrolls_f ppf,
hr_soft_coding_keyflex scl,
pay_element_entries_f peef,
pay_element_entry_values_f peev
WHERE paaf1.assignment_id = p_assignment_id
AND fs.session_id = userenv('sessionid')
AND fs.effective_date BETWEEN paaf1.effective_start_date AND paaf1.effective_end_date
AND paaf1.person_id = paaf2.person_id
AND nvl(paaf2.primary_flag, 'N') = 'Y'
AND fs.effective_date BETWEEN paaf2.effective_start_date AND paaf2.effective_end_date
AND paaf2.payroll_id = ppf.payroll_id
AND fs.effective_date BETWEEN ppf.effective_start_date AND ppf.effective_end_date
AND ppf.soft_coding_keyflex_id = scl.soft_coding_keyflex_id
AND scl.segment1 = l_asg_tax_ref
AND paaf2.assignment_id = peef.assignment_id
AND fs.effective_date BETWEEN peef.effective_start_date AND peef.effective_end_date
AND peef.element_entry_id = peev.element_entry_id
AND fs.effective_date BETWEEN peev.effective_start_date AND peev.effective_end_date
AND peev.input_value_id IN (g_eas_main_iv_id, g_eas_ntpp_main_iv_id);
SELECT nvl(regular_payment_date, to_date('01-01-0001', 'DD-MM-YYYY'))
FROM per_time_periods ptp
WHERE l_asg_period_start_date BETWEEN ptp.start_date AND ptp.end_Date
AND ptp.payroll_id = l_payroll_id;
SELECT scl.segment1
FROM hr_soft_coding_keyflex scl,
fnd_sessions fs,
pay_payrolls_f ppf,
per_all_assignments_f paaf
WHERE paaf.assignment_id = p_assignment_id
AND fs.session_id = userenv('sessionid')
AND fs.effective_date BETWEEN paaf.effective_start_date AND paaf.effective_end_date
AND ppf.payroll_id = paaf.payroll_id
AND fs.effective_date BETWEEN ppf.effective_start_date AND ppf.effective_end_Date
AND ppf.soft_coding_keyflex_id = scl.soft_coding_keyflex_id;
SELECT ppf.payroll_id
FROM fnd_sessions fs,
per_all_assignments_f paaf1,
per_all_assignments_f paaf2,
pay_all_payrolls_f ppf,
hr_soft_coding_keyflex scl,
pay_element_entries_f peef,
pay_element_entry_values_f peev
WHERE paaf1.assignment_id = p_assignment_id
AND fs.session_id = userenv('sessionid')
AND fs.effective_date BETWEEN paaf1.effective_start_date AND paaf1.effective_end_date
AND paaf1.person_id = paaf2.person_id
AND fs.effective_date BETWEEN paaf2.effective_start_date AND paaf2.effective_end_date
AND paaf2.payroll_id = ppf.payroll_id
AND fs.effective_date BETWEEN ppf.effective_start_date AND ppf.effective_end_date
AND ppf.soft_coding_keyflex_id = scl.soft_coding_keyflex_id
AND scl.segment1 = l_asg_tax_ref
AND paaf2.assignment_id = peef.assignment_id
AND fs.effective_date BETWEEN peef.effective_start_date AND peef.effective_end_date
AND peef.element_entry_id = peev.element_entry_id
AND fs.effective_date BETWEEN peev.effective_start_date AND peev.effective_end_date
AND peev.input_value_id IN (g_eas_main_iv_id, g_eas_ntpp_main_iv_id)
AND nvl(SCREEN_ENTRY_VALUE, 'N') = 'Y';
SELECT ppf.payroll_id
FROM fnd_sessions fs,
per_all_assignments_f paaf1,
per_all_assignments_f paaf2,
pay_all_payrolls_f ppf,
hr_soft_coding_keyflex scl,
pay_element_entries_f peef,
pay_element_entry_values_f peev
WHERE paaf1.assignment_id = p_assignment_id
AND fs.session_id = userenv('sessionid')
AND fs.effective_date BETWEEN paaf1.effective_start_date AND paaf1.effective_end_date
AND paaf1.person_id = paaf2.person_id
AND nvl(paaf2.primary_flag, 'N') = 'Y'
AND fs.effective_date BETWEEN paaf2.effective_start_date AND paaf2.effective_end_date
AND paaf2.payroll_id = ppf.payroll_id
AND fs.effective_date BETWEEN ppf.effective_start_date AND ppf.effective_end_date
AND ppf.soft_coding_keyflex_id = scl.soft_coding_keyflex_id
AND scl.segment1 = l_asg_tax_ref
AND paaf2.assignment_id = peef.assignment_id
AND fs.effective_date BETWEEN peef.effective_start_date AND peef.effective_end_date
AND peef.element_entry_id = peev.element_entry_id
AND fs.effective_date BETWEEN peev.effective_start_date AND peev.effective_end_date
AND peev.input_value_id IN (g_eas_main_iv_id, g_eas_ntpp_main_iv_id);
SELECT number_per_fiscal_year
FROM per_time_periods ptp, per_time_period_types ptpt, fnd_sessions fs
WHERE fs.session_id = userenv('sessionid')
AND fs.effective_date BETWEEN ptp.start_date AND ptp.end_Date
AND ptp.payroll_id = l_payroll_id
AND ptp.period_type = ptpt.period_type;
SELECT scl.segment1
FROM hr_soft_coding_keyflex scl,
fnd_sessions fs,
pay_payrolls_f ppf,
per_all_assignments_f paaf
WHERE paaf.assignment_id = p_assignment_id
AND fs.session_id = userenv('sessionid')
AND fs.effective_date BETWEEN paaf.effective_start_date AND paaf.effective_end_date
AND ppf.payroll_id = paaf.payroll_id
AND fs.effective_date BETWEEN ppf.effective_start_date AND ppf.effective_end_Date
AND ppf.soft_coding_keyflex_id = scl.soft_coding_keyflex_id;
SELECT piv.input_value_id
FROM fnd_sessions fs,
pay_element_types_f pet,
pay_input_values_f piv
WHERE fs.session_id = userenv('sessionid')
AND pet.element_name = p_ele_name
AND pet.business_group_id IS NULL
AND pet.legislation_code = 'GB'
AND fs.effective_date BETWEEN pet.effective_start_date AND pet.effective_end_date
AND pet.element_type_id = piv.element_type_id
AND piv.name = p_iv_name
AND piv.business_group_id IS NULL
AND piv.legislation_code = 'GB'
AND fs.effective_date BETWEEN piv.effective_start_date AND piv.effective_end_date;
SELECT peef.element_entry_id
FROM fnd_sessions fs,
per_all_assignments_f paaf1,
per_all_assignments_f paaf2,
pay_all_payrolls_f ppf,
hr_soft_coding_keyflex scl,
pay_element_entries_f peef,
pay_element_entry_values_f peev
WHERE paaf1.assignment_id = p_assignment_id
AND fs.session_id = userenv('sessionid')
AND fs.effective_date BETWEEN paaf1.effective_start_date AND paaf1.effective_end_date
AND paaf1.person_id = paaf2.person_id
AND fs.effective_date BETWEEN paaf2.effective_start_date AND paaf2.effective_end_date
AND paaf2.payroll_id = ppf.payroll_id
AND fs.effective_date BETWEEN ppf.effective_start_date AND ppf.effective_end_date
AND ppf.soft_coding_keyflex_id = scl.soft_coding_keyflex_id
AND scl.segment1 = l_asg_tax_ref
AND paaf2.assignment_id = peef.assignment_id
AND fs.effective_date BETWEEN peef.effective_start_date AND peef.effective_end_date
AND peef.element_entry_id = peev.element_entry_id
AND fs.effective_date BETWEEN peev.effective_start_date AND peev.effective_end_date
AND peev.input_value_id IN (g_eas_main_iv_id, g_eas_ntpp_main_iv_id)
AND nvl(SCREEN_ENTRY_VALUE, 'N') = 'Y'
AND peef.target_entry_id IS NULL;
SELECT peef.element_entry_id
FROM fnd_sessions fs,
per_all_assignments_f paaf1,
per_all_assignments_f paaf2,
pay_all_payrolls_f ppf,
hr_soft_coding_keyflex scl,
pay_element_entries_f peef,
pay_element_entry_values_f peev
WHERE paaf1.assignment_id = p_assignment_id
AND fs.session_id = userenv('sessionid')
AND fs.effective_date BETWEEN paaf1.effective_start_date AND paaf1.effective_end_date
AND paaf1.person_id = paaf2.person_id
AND nvl(paaf2.primary_flag, 'N') = 'Y'
AND fs.effective_date BETWEEN paaf2.effective_start_date AND paaf2.effective_end_date
AND paaf2.payroll_id = ppf.payroll_id
AND fs.effective_date BETWEEN ppf.effective_start_date AND ppf.effective_end_date
AND ppf.soft_coding_keyflex_id = scl.soft_coding_keyflex_id
AND scl.segment1 = l_asg_tax_ref
AND paaf2.assignment_id = peef.assignment_id
AND fs.effective_date BETWEEN peef.effective_start_date AND peef.effective_end_date
AND peef.element_entry_id = peev.element_entry_id
AND fs.effective_date BETWEEN peev.effective_start_date AND peev.effective_end_date
AND peev.input_value_id IN (g_eas_main_iv_id, g_eas_ntpp_main_iv_id)
AND peef.target_entry_id IS NULL;
SELECT peev.screen_entry_value
FROM fnd_sessions fs, pay_element_entry_values_f peev
WHERE fs.session_id = userenv('sessionid')
AND fs.effective_date BETWEEN peev.effective_start_date AND peev.effective_end_date
AND peev.element_entry_id = l_entry_id
AND peev.input_value_id IN (l_eas_iv_id, l_eas_ntpp_iv_id);
select /*+ INDEX(C PAY_USER_COLUMNS_FK1)
INDEX(R PAY_USER_ROWS_F_FK1)
INDEX(CINST PAY_USER_COLUMN_INSTANCES_N1)
ORDERED */
CINST.value, C.user_column_name
from pay_user_tables TAB
, pay_user_columns C
, pay_user_rows_f R
, pay_user_column_instances_f CINST
where TAB.user_table_name = l_table_name
and TAB.legislation_code = 'GB'
and C.user_table_id = TAB.user_table_id
and C.legislation_code = 'GB'
and C.user_column_name in ('AMOUNT','PERCENT','PREV_BAND_LIMIT','OPERATOR')
and CINST.user_column_id = C.user_column_id
and R.user_table_id = TAB.user_table_id
and l_effective_date between R.effective_start_date
and R.effective_end_date
and R.legislation_code = 'GB'
and fnd_number.canonical_to_number (l_row_value)
between fnd_number.canonical_to_number (R.row_low_range_or_name)
and fnd_number.canonical_to_number (R.row_high_range)
and TAB.user_key_units = 'N'
and CINST.user_row_id = R.user_row_id
and l_effective_date between CINST.effective_start_date
and CINST.effective_end_date
and CINST.legislation_code = 'GB';