[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
select hr_assignment_sets_s.nextval
from dual;
select payroll_action_id
from pay_assignment_Actions
where serial_number = p_check_number;
SELECT DISTINCT ppa.payroll_action_id
,ppa.payroll_id
,ppp.org_payment_method_id
,ppa.payment_type_id
,ppa.effective_date
,ppa.cheque_procedure
,ppa.cheque_report
,ppa.start_cheque_number
,ppa.start_date
,ppa.consolidation_set_id
,papf.payroll_name
,pcs.consolidation_set_name
,papf.business_group_id
,paa.assignment_id
-- ,popmf.org_payment_method_name
INTO check_details_rec
FROM pay_payroll_actions ppa
,pay_assignment_actions paa
,pay_all_payrolls_f papf
,pay_consolidation_sets pcs
,pay_org_payment_methods_f popmf
,pay_pre_payments ppp
WHERE paa.assignment_action_id = p_check_assignment_action
AND ppp.pre_payment_id = paa.pre_payment_id
AND ppa.payroll_action_id = paa.payroll_action_id
AND papf.payroll_id = ppa.payroll_id
AND pcs.consolidation_set_id = ppa.consolidation_set_id
AND (
(
ppa.org_payment_method_id = popmf.org_payment_method_id
)
OR (
popmf.org_payment_method_id IN
(
SELECT ppp.org_payment_method_id
FROM pay_pre_payments ppp
,pay_assignment_actions paa
WHERE paa.payroll_action_id = ppa.payroll_action_id
AND paa.pre_payment_id = ppp.pre_payment_id
)
)
)
AND to_date (p_end_date
,l_format) BETWEEN papf.effective_start_date
AND papf.effective_end_date
AND to_date (p_end_date
,l_format) BETWEEN popmf.effective_start_date
AND popmf.effective_end_date;
select lookup_code into l_sort_sequence
from hr_lookups
where lookup_type = 'CHEQUE_PROCEDURE'
and lookup_code = 'DEFAULT';
select lookup_code into l_check_style
from hr_lookups
where lookup_type='CHEQUE_REPORT'
and lookup_code='PAYUSCHK';
HR_ASSIGNMENT_SETS_PKG.insert_row(
p_rowid => p_asg_set_rowid,
p_assignment_set_id => l_asg_set_id,
p_business_group_id => check_details_rec.business_group_id,
p_payroll_id => check_details_rec.payroll_id,
p_assignment_set_name => l_asg_set_name,
p_formula_id => null);
HR_ASSIGNMENT_SET_AMDS_PKG.insert_row(
p_rowid => p_asg_rowid,
p_assignment_id => check_details_rec.assignment_id,
p_assignment_set_id => l_asg_set_id,
p_include_or_exclude => 'I');
pay_flow_requests_pkg.insert_child_request(p_check_assignment_action,
l_request_id);
update pay_payroll_actions
set assignment_set_id = null,
last_update_date = sysdate,
last_updated_by = fnd_global.user_id,
last_update_login = fnd_global.login_id
where payroll_action_id = l_curr_payroll_action_id;
HR_ASSIGNMENT_SET_AMDS_PKG.delete_row(p_asg_rowid);
HR_ASSIGNMENT_SETS_PKG.delete_row(p_asg_set_rowid); */
select ppa.payroll_action_id, paa.serial_number
into l_payroll_action_id, l_start_cheque_number
from pay_payroll_actions ppa, pay_assignment_actions paa
where ppa.payroll_action_id = paa.payroll_action_id
and paa.assignment_action_id = p_check_assignment_action;
select distinct(paa.assignment_action_id),ppa.payroll_id,
paa.assignment_id, ppp.pre_payment_id, paa2.serial_number
into l_prepayment_asg_action, l_payroll_id, l_assignment_id,
l_pre_payment_id, l_serial_number
from pay_payroll_actions ppa, pay_assignment_actions paa,
pay_assignment_actions paa2, pay_all_payrolls_f papf,
pay_pre_payments ppp, pay_action_interlocks pal
where pal.locking_action_id = p_check_assignment_action
and paa2.assignment_action_id = p_check_assignment_action
and paa.assignment_action_id = pal.locked_action_id
and ppa.payroll_action_id = paa.payroll_action_id
and ppp.assignment_action_id = paa.assignment_action_id
and ppa.effective_date between papf.effective_start_date
and papf.effective_end_date
and ppp.pre_payment_id = paa2.pre_payment_id;
IS ( select pal2.locked_action_id
from pay_action_interlocks pal1,
pay_action_interlocks pal2
where pal1.locking_action_id = p_check_assignment_action
and pal1.locked_action_id = pal2.locking_action_id ) ;
l_temp number; -- dummy variable to collect value from select query that checks existance
select count(*)
into l_temp
from pay_payroll_actions
where action_type = 'V'
and action_status = 'P';
select ppa.payroll_id, ppa.consolidation_set_id,
papf.business_group_id,
ppa.action_type, ppa.action_status,
ppa.action_population_status
into payroll_action_rec
from pay_payroll_actions ppa, pay_assignment_actions paa,
pay_all_payrolls_f papf, pay_consolidation_sets pcs
where paa.assignment_action_id = l_payroll_run_asg_action
and ppa.payroll_action_id = paa.payroll_action_id
and papf.payroll_id = ppa.payroll_id
and pcs.consolidation_set_id = ppa.consolidation_set_id
and to_date(p_effective_date,l_format) between papf.effective_start_date and
papf.effective_end_date;
select distinct 1
into l_temp
from pay_assignment_actions ac2,
pay_payroll_actions pa2,
pay_action_interlocks pai
where pai.locked_action_id = l_payroll_run_asg_action
and ac2.assignment_action_id = pai.locking_action_id
and pa2.payroll_action_id = ac2.payroll_action_id
and pa2.action_type = 'V';