[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT element_reporting_name
,classification_name
,payment
FROM pay_nz_soe_run_elements_v1
WHERE assignment_action_id = p_assignment_action_id
AND assignment_id = p_assignment_id
AND classification_name IS NOT NULL
AND element_reporting_name NOT IN ('SSCWT Deduction','ESCT Deduction'); -- bug 7494658
SELECT element_reporting_name
,classification_name
,payment
FROM pay_nz_soe_run_elements_v2
WHERE assignment_action_id = p_assignment_action_id
AND assignment_id = p_assignment_id
AND classification_name IS NOT NULL
AND element_reporting_name NOT IN ('SSCWT Deduction','ESCT Deduction'); -- bug 7494658
SELECT action_information_id
,action_information5
FROM pay_action_information
WHERE action_information_category = 'EMPLOYEE NET PAY DISTRIBUTION'
AND action_context_id = p_assact_id
AND action_context_type = 'AAP';
SELECT tax_unit_id
FROM pay_assignment_actions
WHERE assignment_action_id = p_assignment_action_id;
SELECT hr_general_utilities.Get_lookup_Meaning('NZ_BANK',p_bank_code)
FROM dual;
hr_utility.set_location('Calling update Net Pay Distribution',80);
pay_action_information_api.update_action_information
( p_action_information_id => net_pay_rec.action_information_id
, p_object_version_number => l_ovn
, p_action_information9 => l_bank_name
);
SELECT element_reporting_name
,start_date
,end_date
,absence_duration
FROM pay_nz_asg_leave_taken_v1
WHERE time_period_id = p_time_period_id
AND assignment_id = p_assignment_id
AND date_earned = p_date_earned;
SELECT element_reporting_name
,start_date
,end_date
,absence_duration
FROM pay_nz_asg_leave_taken_v2
WHERE time_period_id = p_time_period_id
AND assignment_id = p_assignment_id
AND date_earned = p_date_earned;
SELECT element_reporting_name
,start_date
,end_date
,absence_duration
FROM pay_nz_asg_leave_taken_v3
WHERE time_period_id = p_time_period_id
AND assignment_id = p_assignment_id
AND date_earned = p_date_earned;
SELECT element_reporting_name
,start_date
,end_date
,absence_duration
FROM pay_nz_asg_leave_taken_v4
WHERE time_period_id = p_time_period_id
AND assignment_id = p_assignment_id
AND date_earned = p_date_earned;
SELECT pap.accrual_plan_name
,hr_general_utilities.get_lookup_meaning('US_PTO_ACCRUAL',pap.accrual_category)
,pap.accrual_units_of_measure
,ppa.payroll_id
,pap.business_group_id
,pap.accrual_plan_id
FROM pay_accrual_plans pap,
pay_element_types_f pet,
pay_element_links_f pel,
pay_element_entries_f pee,
pay_assignment_actions paa,
pay_payroll_actions ppa
WHERE pet.element_type_id = pap.accrual_plan_element_type_id
AND pel.element_type_id = pet.element_type_id
AND pee.element_link_id = pel.element_link_id
AND paa.assignment_id = pee.assignment_id
AND ppa.payroll_action_id = paa.payroll_action_id
AND pap.accrual_category = 'NZAL'
AND ppa.action_type IN('R','Q')
AND ppa.action_status = 'C'
AND ppa.date_earned BETWEEN pet.effective_start_date
AND pet.effective_end_date
AND ppa.date_earned BETWEEN pel.effective_start_date
AND pel.effective_end_date
AND ppa.date_earned BETWEEN pee.effective_start_date
AND pee.effective_end_date
AND paa.assignment_id = p_assignment_id
AND paa.assignment_action_id = p_assignment_action_id;
SELECT paa_arch_chd.assignment_action_id chld_arc_assignment_action_id
,paa_arch_chd.payroll_action_id arch_payroll_action_id
,paa_pre.assignment_action_id pre_assignment_action_id
,paa_run.assignment_action_id run_assignment_action_id
,paa_run.payroll_action_id run_payroll_action_id
,ppa_pre.effective_date pre_effective_date
,paa_arch_chd.assignment_id
,ppa_run.effective_date run_effective_date
,ppa_run.date_earned run_date_earned
,ptp.end_date period_end_date
,ptp.time_period_id
,ptp.start_date
,ptp.regular_payment_date
FROM pay_assignment_actions paa_arch_chd
,pay_assignment_actions paa_arch_mst
,pay_assignment_actions paa_pre
,pay_action_interlocks pai_pre
,pay_assignment_actions paa_run
,pay_action_interlocks pai_run
,pay_payroll_actions ppa_pre
,pay_payroll_actions ppa_run
,per_time_periods ptp
,per_business_groups pbg
WHERE paa_arch_mst.assignment_action_id = p_master_aa_id
AND paa_arch_chd.source_action_id = paa_arch_mst.assignment_action_id
AND paa_arch_chd.payroll_action_id = paa_arch_mst.payroll_action_id
AND ppa_pre.business_group_id = pbg.business_group_id
AND pbg.business_group_id = ppa_run.business_group_id
AND ppa_pre.payroll_id = ppa_run.payroll_id
AND paa_arch_chd.assignment_id = paa_arch_mst.assignment_id
AND pai_pre.locking_action_id = paa_arch_mst.assignment_action_id
AND pai_pre.locked_action_id = paa_pre.assignment_action_id
AND pai_run.locking_action_id = paa_arch_chd.assignment_action_id
AND pai_run.locked_action_id = paa_run.assignment_action_id
AND ppa_pre.payroll_action_id = paa_pre.payroll_action_id
AND ppa_pre.action_type IN ('P','U')
AND ppa_run.payroll_action_id = paa_run.payroll_action_id
AND ppa_run.action_type IN ('R','Q')
AND ptp.payroll_id = ppa_run.payroll_id
AND ppa_run.date_earned BETWEEN ptp.start_date
AND ptp.end_date
-- Get the highest in sequence for this payslip
AND paa_run.action_sequence =
(
SELECT MAX(paa_run2.action_sequence)
FROM pay_assignment_actions paa_run2
,pay_action_interlocks pai_run2
WHERE pai_run2.locking_action_id = paa_arch_chd.assignment_action_id
AND pai_run2.locked_action_id = paa_run2.assignment_action_id
);
SELECT pps.actual_termination_date
FROM pay_payroll_actions ppa,
pay_assignment_actions paa,
per_time_periods ptp,
per_all_assignments_f paf,
per_periods_of_service pps
WHERE paa.assignment_action_id = p_assignment_action_id
AND ppa.payroll_action_id = paa.payroll_action_id
AND ptp.payroll_id = ppa.payroll_id
AND paf.assignment_id = paa.assignment_id
AND pps.period_of_service_id = paf.period_of_service_id
AND ppa.date_earned between ptp.start_date AND ptp.end_date
AND pps.actual_termination_date between ptp.start_date AND ptp.end_date;