[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
select ppf.payroll_name PAYROLL_NAME,
to_char(count(paa.assignment_action_id)) ASG_COUNT,
paa.action_status ASG_STATUS
from pay_assignment_actions paa,
pay_payroll_actions ppa,
pay_all_payrolls_f ppf
where paa.payroll_action_id = ppa.payroll_action_id
and ppa.request_id = to_number(p_req_id)
and ppa.business_group_id = ln_business_group_id
and ppa.payroll_id = ppf.payroll_id
and ppf.payroll_id = ln_payroll_id
and ppa.effective_date between
ppf.effective_start_date and
ppf.effective_end_date
and ppa.effective_date = trunc(to_date(ld_payroll_date_paid,'YYYY/MM/DD HH24:MI:SS'))
and ppa.action_type = 'R'
and paa.source_action_id is null
and paa.run_type_id is null
group by ppf.payroll_name,paa.action_status;
select pbg.name into lv_business_group_name
from per_business_groups pbg
where pbg.business_group_id = ln_business_group_id;
select assignment_set_id
into ln_retro_asg_set_id
from hr_assignment_sets
where business_group_id = X_bg_id
and assignment_set_name like lv_retro_asg_set||'%';
select assignment_set_id
into ln_retro_asg_set_id
from hr_assignment_sets
where business_group_id = X_bg_id
and assignment_set_name like lv_retro_asg_set||'%';
cursor c1 is select
furg.user_id,
furg.responsibility_id,
furg.responsibility_application_id
from fnd_user_resp_groups furg,
fnd_user fu,
fnd_responsibility fr
where fu.user_id = furg.user_id
and furg.responsibility_id = fr.responsibility_id
and fu.user_name = 'JATIN'
and responsibility_key like 'JJ CA HRMS MANAGER';