[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT business_group_id
FROM per_all_assignments_f
WHERE assignment_id = p_asg_id;
SELECT payroll_id
FROM pay_all_payrolls_f
WHERE payroll_name = l_payroll_name
AND nvl(business_group_id, p_bus_group_id) = p_bus_group_id
AND ben_ext_person.g_effective_Date BETWEEN effective_start_date AND effective_end_Date;
SELECT person_id
FROM per_all_people_f
WHERE employee_number = l_employee_number
AND nvl(business_group_id, p_bus_group_id) = p_bus_group_id
AND ben_ext_person.g_effective_Date BETWEEN effective_start_date AND effective_end_Date;
SELECT consolidation_set_id
FROM pay_consolidation_sets
WHERE consolidation_Set_name = l_consolidation_set
AND nvl(business_group_id, p_bus_group_id) = p_bus_group_id;
SELECT assignment_set_id
FROM hr_assignment_sets
WHERE assignment_set_name = l_assignment_set
AND nvl(business_group_id, p_bus_group_id) = p_bus_group_id;
SELECT min(effective_start_date) min_start_date, max(effective_end_date) max_end_date
FROM per_all_assignments_f
WHERE assignment_id = p_asg_id;
SELECT pp.payroll_id, asg.person_id, pp.consolidation_set_id, flex.segment1 tax_dist
FROM pay_all_payrolls_f pp,
per_all_assignments_f asg,
hr_soft_coding_keyflex flex
WHERE asg.assignment_id = p_asg_id
AND asg.payroll_id = pp.payroll_id
AND ben_ext_person.g_effective_date BETWEEN pp.effective_start_date AND pp.effective_end_date
AND pp.soft_coding_keyflex_id = flex.soft_coding_keyflex_id
AND asg.effective_start_date < l_ext_end_date
AND asg.effective_end_date > ben_start_date(p_asg_id);
SELECT 'Y' include_flag
FROM hr_assignment_set_amendments hasa,
hr_assignment_sets has,
per_all_assignments_f paaf
WHERE has.assignment_set_id = l_ext_asg_set_id
AND paaf.assignment_id = p_asg_id
-- AND ben_ext_person.g_effective_date BETWEEN paaf.effective_start_date AND paaf.effective_end_date
AND has.assignment_set_id = hasa.assignment_set_id (+)
AND NVL (hasa.assignment_id, paaf.assignment_id) = paaf.assignment_id
AND NVL (hasa.include_or_exclude, 'I') = 'I'
AND NVL (has.payroll_id, paaf.payroll_id) = paaf.payroll_id;
select max(paa.assignment_action_id)
from per_time_periods ptp,
pay_payroll_actions pact,
pay_assignment_actions paa
where paa.assignment_id = p_assignment_id
and paa.payroll_action_id = pact.payroll_action_id
and pact.time_period_id = ptp.time_period_id
and pact.action_type in ('Q','R','B','I','V')
and paa.action_status = 'C'
and pact.effective_date <= p_ext_end_date
and ptp.regular_payment_date between p_ben_start_date
and p_ext_end_date;
select max(paa.assignment_action_id)
from per_time_periods ptp,
pay_payroll_actions pact,
pay_assignment_actions paa
where paa.assignment_id = p_assignment_id
and paa.payroll_action_id = pact.payroll_action_id
and pact.time_period_id = ptp.time_period_id
and pact.action_type in ('Q','R','B','I','V')
and paa.action_status = 'C'
and pact.effective_date <= p_tax_year_end_date
and ptp.regular_payment_date between p_ben_start_date
and p_tax_year_end_date;
select greatest(pps.date_start, l_tax_year_start)
from per_periods_of_service pps,
per_all_assignments_f paf
where paf.period_of_service_id = pps.period_of_service_id
and paf.assignment_id = p_assignment_id;
select least(nvl(pps.actual_termination_date,hr_general.end_of_time),
l_tax_year_end)
from per_periods_of_service pps,
per_all_assignments_f paf
where paf.period_of_service_id = pps.period_of_service_id
and paf.assignment_id = p_assignment_id;
select greatest(min(paf.effective_start_date),l_tax_year_start)
from per_all_assignments_f paf
where paf.assignment_id = p_assignment_id;
select least(max(paf.effective_end_date),l_tax_year_end)
from per_all_assignments_f paf,
per_assignment_status_types past
where paf.assignment_id = p_assignment_id
and past.per_system_status = 'ACTIVE_ASSIGN'
and paf.assignment_status_type_id = past.assignment_status_type_id;
select pdb.defined_balance_id
from pay_balance_types pbt,
pay_defined_balances pdb,
pay_balance_dimensions pbd
where pbt.balance_type_id = pdb.balance_type_id
and pdb.balance_dimension_id = pbd.balance_dimension_id
and pbt.balance_name = 'Mileage Odd Taxable Amt'
and pbd.dimension_name = '_ASG_YTD';
select pdb.defined_balance_id
from pay_balance_types pbt,
pay_defined_balances pdb,
pay_balance_dimensions pbd
where pbt.balance_type_id = pdb.balance_type_id
and pdb.balance_dimension_id = pbd.balance_dimension_id
and pbt.balance_name = 'Mileage Even Taxable Amt'
and pbd.dimension_name = '_ASG_YTD';
select pdb.defined_balance_id
from pay_balance_types pbt,
pay_defined_balances pdb,
pay_balance_dimensions pbd
where pbt.balance_type_id = pdb.balance_type_id
and pdb.balance_dimension_id = pbd.balance_dimension_id
and pbt.balance_name = 'Addl Pasg Odd Taxable Amt'
and pbd.dimension_name = '_ASG_YTD';
select pdb.defined_balance_id
from pay_balance_types pbt,
pay_defined_balances pdb,
pay_balance_dimensions pbd
where pbt.balance_type_id = pdb.balance_type_id
and pdb.balance_dimension_id = pbd.balance_dimension_id
and pbt.balance_name = 'Addl Pasg Even Taxable Amt'
and pbd.dimension_name = '_ASG_YTD';
SELECT ext_rslt_dtl_id
FROM ben_ext_rslt_dtl
WHERE ext_rslt_id = g_ext_rslt_id
AND person_id = g_person_id
AND ext_rcd_id = g_veh_rcd_id
AND val_02 = to_char(p_asg_id)
AND val_04 = p_benefit_end_date
AND val_09 = p_benefit_start_date
AND val_10 = p_benefit_end_date
AND val_12 = p_mileage_balance;
SELECT distinct paa1.assignment_id
FROM per_all_assignments_f paa1, per_all_assignments_f paa2
WHERE paa2.assignment_id = p_asg_id
AND paa2.person_id = paa1.person_id
AND nvl(paa1.primary_flag, 'N') = 'N';
SELECT distinct paa1.assignment_id
FROM per_all_assignments_f paa1, per_all_assignments_f paa2
WHERE paa2.assignment_id = p_asg_id
AND paa2.person_id = paa1.person_id
AND paa1.effective_end_date < paa2.effective_start_date
-- AND paa1.period_of_service_id <> paa2.period_of_service_id
AND nvl(paa1.primary_flag, 'Y') = 'Y';
SELECT rcd.ext_rcd_id
FROM ben_ext_rcd rcd,
ben_ext_rcd_in_file rif,
ben_ext_dfn dfn,
ben_ext_rslt rslt
WHERE rslt.ext_rslt_id = p_ext_rslt_id
AND rslt.ext_dfn_id = dfn.ext_dfn_id
AND dfn.ext_file_id = rif.ext_file_id
AND rif.ext_rcd_id = rcd.ext_rcd_id
AND rcd.name like '%PAY GB P11D Mileage Extract 2003 - Assignment Details Record';
SELECT rcd.ext_rcd_id
FROM ben_ext_rcd rcd,
ben_ext_rcd_in_file rif,
ben_ext_dfn dfn,
ben_ext_rslt rslt
WHERE rslt.ext_rslt_id = p_ext_rslt_id
AND rslt.ext_dfn_id = dfn.ext_dfn_id
AND dfn.ext_file_id = rif.ext_file_id
AND rif.ext_rcd_id = rcd.ext_rcd_id
AND rcd.name like '%PAY GB P11D Mileage Extract 2003 - Mileage and Passenger Record';
SELECT person_id, val_01 asg_id, ext_rslt_dtl_id, object_version_number
FROM ben_ext_rslt_dtl
WHERE ext_rslt_id = p_ext_rslt_id
AND ext_rcd_id = l_asg_rcd_id;
SELECT *
FROM ben_ext_rslt_dtl
WHERE ext_rslt_id = p_ext_rslt_id
AND ext_rcd_id = g_veh_rcd_id
AND person_id = p_person_id;
ben_ext_rslt_dtl_api.delete_ext_rslt_dtl(p_ext_rslt_dtl_id => l_balance_detail.ext_rslt_dtl_id,
p_object_version_number => l_balance_detail.object_version_number);
ben_ext_rslt_dtl_api.delete_ext_rslt_dtl(p_ext_rslt_dtl_id => ext_asg_rec.ext_rslt_dtl_id,
p_object_version_number => l_obj_no);
SELECT distinct paa1.assignment_id
FROM per_all_assignments_f paa1, per_all_assignments_f paa2
WHERE paa2.assignment_id = p_assignment_id
AND paa2.person_id = paa1.person_id
ORDER BY paa1.assignment_id;