[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
select count(*)
from hr_soft_coding_keyflex hsck,
pay_payrolls_f pay, /*Bug 2920728*/
per_time_periods ptp,
per_people_f pap, /*Bug 2920728*/
per_assignments_f paa /*Bug 2920728*/
where hsck.soft_coding_keyflex_id = paa.soft_coding_keyflex_id
and hsck.segment1 = to_char(c_organization_id)
and pay.payroll_id = c_payroll_id
and ptp.time_period_id = c_time_period_id
and paa.location_id = c_location_id
and pap.per_information7 = c_emp_cat_code
and pap.per_information8 = c_work_time_code
and pap.sex = c_sex
and ptp.regular_payment_date between paa.effective_start_date
and paa.effective_end_date
and pap.effective_start_date <= c_survey_date
and pap.effective_end_date >= c_survey_date
and pap.current_employee_flag ='Y'
and pay.payroll_id = ptp.payroll_id
and pap.person_id = paa.person_id
and pay.payroll_id = paa.payroll_id;
select paa.assignment_id,
ptp.regular_payment_date,
pay.period_type payroll_frequency,
hr_nzbal.calc_all_balances(ptp.regular_payment_date,
paa.assignment_id,
c_defined_balance_id) balance
from hr_soft_coding_keyflex hsck,
pay_payrolls_f pay, /*Bug 2929728*/
per_time_periods ptp,
per_people_f pap, /*Bug 2920728*/
per_assignments_f paa /*Bug 2920728*/
where hsck.soft_coding_keyflex_id = paa.soft_coding_keyflex_id
and hsck.segment1 = to_char(c_organization_id)
and pay.payroll_id = c_payroll_id
and ptp.time_period_id = c_time_period_id
and paa.location_id = c_location_id
and pap.sex = c_sex
and ptp.regular_payment_date between paa.effective_start_date
and paa.effective_end_date
and pap.effective_start_date<=c_survey_date
and pap.effective_end_date >=c_survey_date
and pap.current_employee_flag='Y'
and pay.payroll_id = ptp.payroll_id
and pap.person_id = paa.person_id
and pay.payroll_id = paa.payroll_id
and pap.per_information7 = 'E';
select paa.assignment_id,
ptp.regular_payment_date,
pay.period_type payroll_frequency,
hr_nzbal.calc_all_balances(ptp.regular_payment_date,
paa.assignment_id,
c_defined_balance_id) balance
from hr_soft_coding_keyflex hsck,
pay_payrolls_f pay, /*Bug 2920728*/
per_time_periods ptp,
per_people_f pap, /*Bug 2920728*/
per_assignments_f paa /*Bug 2920728*/
where hsck.soft_coding_keyflex_id = paa.soft_coding_keyflex_id
and hsck.segment1 = to_char(c_organization_id)
and pay.payroll_id = c_payroll_id
and ptp.time_period_id = c_time_period_id
and paa.location_id = c_location_id
and pap.sex = c_sex
and ptp.regular_payment_date between paa.effective_start_date
and paa.effective_end_date
and pap.effective_start_date<=c_survey_date
and pap.effective_end_date >=c_survey_date
and pap.current_employee_flag='Y'
and pay.payroll_id = ptp.payroll_id
and pap.person_id = paa.person_id
and pay.payroll_id = paa.payroll_id
and pap.per_information7 = 'E';
select pdb.defined_balance_id
from pay_balance_dimensions pbd,
pay_defined_balances pdb,
pay_balance_types pbt
where pbt.balance_type_id = pdb.balance_type_id
and pbd.balance_dimension_id = pdb.balance_dimension_id
and pbt.balance_name = c_balance_name
and pbd.database_item_suffix = c_balance_dimension;
select paa.normal_hours,
paa.frequency frequency_code, -- to pass to convert_hours
hl.meaning frequency -- to compare to payroll_frequency
from hr_lookups hl,
per_assignments_f paa /*Bug 2920728*/
where hl.application_id = 800
and paa.assignment_id = c_assignment_id
and paa.frequency = hl.lookup_code
and hl.lookup_type = 'FREQUENCY';
select number_per_fiscal_year
from per_time_period_types
where period_type = c_period_type;