[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT element_reporting_name
, classification_group
, amount
, foreign_currency_code
, hours
, exchange_rate
FROM pay_sg_asg_elements_v
WHERE run_assignment_action_id = p_assignment_action_id
AND classification_group IS NOT NULL;
select person_id
from per_assignments_f /* Bug# 2920732 */
where assignment_id = c_assignment_id
and rownum = 1;
SELECT action_information_id
, action_information1 /* Bug No : 2672510 */
, action_information2 /* Bug No : 2538781 */
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 hl.meaning account_type /* Bug 5435029 */
, pea.segment5 bank_name
, ppm.percentage
, pop.currency_code
FROM pay_external_accounts pea
, pay_personal_payment_methods_f ppm
, pay_org_payment_methods_f pop
, pay_pre_payments ppp
, hr_lookups hl
WHERE ppm.personal_payment_method_id(+) = ppp.personal_payment_method_id
AND pop.org_payment_method_id = ppp.org_payment_method_id
AND pea.segment3 = hl.lookup_code (+)
AND hl.lookup_type(+) = 'SG_ACCOUNT_TYPE'
AND pea.external_account_id(+) = ppm.external_account_id
AND ppp.assignment_action_id = p_curr_pymt_ass_act_id
AND ((ppp.personal_payment_method_id = l_personal_payment_method_id) or
(ppp.org_payment_method_id = l_org_payment_method_id and ppp.personal_payment_method_id is null)) /* Bug No : 2672510 */
AND p_pre_effective_date BETWEEN pop.effective_start_date
AND pop.effective_end_date
AND p_pre_effective_date BETWEEN nvl(ppm.effective_start_date, p_pre_effective_date)
AND nvl(ppm.effective_end_date, p_pre_effective_date); /* Bug 5730336 */
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_information6 => l_account_type /* Bug 5435029 */
, p_action_information9 => l_bank_name
, p_action_information12 => l_percentage
, p_action_information13 => l_currency_code
);
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 = 'SGAL'
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_pre.assignment_action_id pre_assignment_action_id,
paa_run.assignment_action_id run_assignment_action_id,
ppa_pre.effective_date pre_effective_date,
paa_arch_chd.assignment_id,
ppa_run.payroll_action_id,
ppa_run.effective_date run_effective_date,
ppa_run.date_earned run_date_earned,
ptp.start_date period_start_date,
ptp.end_date period_end_date,
ptp.regular_payment_date,
ptp.time_period_id
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
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 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;