[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT fnd_number.canonical_to_number(hoi.org_information20) scheme_id,
hoi.org_information2 scheme_name
from hr_organization_units hou,
hr_organization_information hoi
where hoi.org_information_context = 'HK_MPF_SCHEMES'
and hou.business_group_id = c_business_group_id
and hou.organization_id = hoi.organization_id;
SELECT fnd_number.canonical_to_number(prrv.result_value)
FROM pay_assignment_actions paa,
pay_run_results prr,
pay_run_result_values prrv,
pay_input_values_f pivf
WHERE prr.run_result_id = c_run_result_id
AND paa.assignment_action_id = c_assignment_action_id
AND prr.run_result_id = prrv.run_result_id
AND prrv.input_value_id = pivf.input_value_id
AND pivf.legislation_code = 'HK'
AND pivf.name = 'Source'
AND prr.assignment_action_id = paa.assignment_action_id;
SELECT element_reporting_name
, classification_name
, payment_amount
, assessed_ri
, fnd_date.date_to_canonical(to_date(period_start_date,'YYYY/MM/DD HH24:MI:SS')) period_start_date
, fnd_date.date_to_canonical(to_date(period_end_date,'YYYY/MM/DD HH24:MI:SS')) period_end_date
FROM PAY_HK_ASG_ELEMENT_PAYMENTS_V
WHERE assignment_action_id = p_assignment_action_id
AND classification_name IS NOT NULL;
SELECT tax_unit_id
FROM pay_assignment_actions
WHERE assignment_action_id = p_assignment_action_id;
SELECT action_information_id
,action_information1
,action_information2
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,mailstop
FROM pay_hk_asg_payment_runs_v
WHERE assignment_action_id = p_assignment_action_id;
SELECT pay_core_utils.get_parameter('MPF_DUE_DATE',legislative_parameters)
FROM pay_payroll_actions ppa
WHERE ppa.payroll_action_id = p_payroll_action_id;
SELECT pea.segment2 branch_code
, pea.segment3 account_number
, 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(+) = 'HK_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 5736815 */
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_account
, p_action_information10 => l_currency
);
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 = 'HKAL'
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 paf.effective_start_date and paf.effective_end_date
AND pps.actual_termination_date between ptp.start_date AND ptp.end_date;
SELECT prrv.result_value
FROM pay_input_values_f pivf,
pay_run_result_values prrv
WHERE prrv.run_result_id = p_run_result_id
AND pivf.input_value_id = prrv.input_value_id
AND pivf.name = 'Assessed RI';