[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
select user_entity_id
from ff_user_entities fue
where fue.user_entity_name = p_user_entity_name
and fue.legislation_code = 'CA';
select ppa.start_date,
ppa.effective_date,
pay_core_utils.get_parameter('PERSON_ID',ppa.legislative_parameters),
pay_core_utils.get_parameter('ASSIGNMENT_SET',ppa.legislative_parameters)
from pay_payroll_actions ppa
where payroll_action_id = p_pactid;
p_sqlstr := 'select distinct person_id from
per_assignments_f paf,
ff_archive_items fai,
pay_payroll_actions ppa,
pay_assignment_actions paa
where
fai.user_entity_id = ' || l_roe_date_uid || ' and
fnd_date.canonical_to_date(fai.value) between
ppa.start_date and
ppa.effective_date and
ppa.payroll_action_id = :p_pactid and
ppa.business_group_id = paf.business_group_id and
paa.assignment_action_id = fai.context1 and
paf.assignment_id = paa.assignment_id and
fnd_date.canonical_to_date(fai.value) between
paf.effective_start_date and
paf.effective_end_date and
person_id = '|| p_person_id;
p_sqlstr := 'select distinct paf.person_id from
per_assignments_f paf,
ff_archive_items fai,
pay_payroll_actions ppa,
pay_assignment_actions paa,
HR_ASSIGNMENT_SET_AMENDMENTS haa
where
fai.user_entity_id = ' || l_roe_date_uid || ' and
fnd_date.canonical_to_date(fai.value) between
ppa.start_date and
ppa.effective_date and
ppa.payroll_action_id = :p_pactid and
ppa.business_group_id = paf.business_group_id and
paa.assignment_action_id = fai.context1 and
paf.assignment_id = paa.assignment_id and
fnd_date.canonical_to_date(fai.value) between
paf.effective_start_date and
paf.effective_end_date and
haa.assignment_id = paf.assignment_id and
haa.include_or_exclude = ''I'' and
haa.assignment_set_id = '|| p_assignment_set;
p_sqlstr := 'select distinct person_id from
per_assignments_f paf,
ff_archive_items fai,
pay_payroll_actions ppa,
pay_assignment_actions paa
where
fai.user_entity_id = ' || l_roe_date_uid || ' and
fnd_date.canonical_to_date(fai.value) between
ppa.start_date and
ppa.effective_date and
ppa.payroll_action_id = :p_pactid and
ppa.business_group_id = paf.business_group_id and
paa.assignment_action_id = fai.context1 and
paf.assignment_id = paa.assignment_id and
fnd_date.canonical_to_date(fai.value) between
paf.effective_start_date and
paf.effective_end_date';
select pay_assignment_actions_s.nextval
from dual;
select
paa.assignment_id assignment_id,
paa.tax_unit_id gre_id,
fai2.value payroll_id
from
pay_payroll_actions ppa,
pay_assignment_actions paa,
ff_archive_items fai1,
ff_archive_items fai2,
per_assignments_f paf
where
ppa.report_type = 'ROE' and
ppa.report_category = 'ROEC' and
ppa.report_qualifier = 'ROEQ' and
ppa.payroll_action_id = paa.payroll_action_id and
paa.assignment_action_id = fai1.context1 and
fai1.user_entity_id=l_roe_date_id and
fnd_date.canonical_to_date(fai1.value) between
fnd_date.canonical_to_date(to_char(p_start_date,'yyyy/mm/dd hh24:mi:ss')) and
fnd_date.canonical_to_date(to_char(p_end_date,'yyyy/mm/dd hh24:mi:ss')) and
fai1.context1 = fai2.context1 and
fai2.user_entity_id = l_roe_payroll_id and
paa.assignment_id = paf.assignment_id and
fnd_date.canonical_to_date(fai1.value) between
paf.effective_start_date and
paf.effective_end_date and
paf.assignment_type = 'E' and
paf.person_id between
p_stperson and
p_endperson;
select
paa.assignment_id assignment_id,
paa.tax_unit_id gre_id,
fai2.value payroll_id
from
pay_payroll_actions ppa,
pay_assignment_actions paa,
ff_archive_items fai1,
ff_archive_items fai2,
per_assignments_f paf,
pay_population_ranges ppr
where
ppa.report_type = 'ROE' and
ppa.report_category = 'ROEC' and
ppa.report_qualifier = 'ROEQ' and
ppa.payroll_action_id = paa.payroll_action_id and
paa.assignment_action_id = fai1.context1 and
fai1.user_entity_id=l_roe_date_id and
fnd_date.canonical_to_date(fai1.value) between
fnd_date.canonical_to_date(to_char(p_start_date,'yyyy/mm/dd hh24:mi:ss')) and
fnd_date.canonical_to_date(to_char(p_end_date,'yyyy/mm/dd hh24:mi:ss')) and
fai1.context1 = fai2.context1 and
fai2.user_entity_id = l_roe_payroll_id and
paa.assignment_id = paf.assignment_id and
fnd_date.canonical_to_date(fai1.value) between
paf.effective_start_date and
paf.effective_end_date and
paf.assignment_type = 'E' and
ppr.payroll_action_id = p_pactid
AND ppr.chunk_number = p_chunk
AND paf.person_id = ppr.person_id;
select
paa.assignment_action_id locked_action_id
from
pay_payroll_actions ppa,
pay_assignment_actions paa,
ff_archive_items fai1,
ff_archive_items fai2
where
ppa.report_type = 'ROE' and
ppa.report_category = 'ROEC' and
ppa.report_qualifier = 'ROEQ' and
ppa.payroll_action_id = paa.payroll_action_id and
paa.tax_unit_id = l_gre_id and
paa.assignment_id = l_assignment_id and
paa.assignment_action_id = fai1.context1 and
fai1.user_entity_id = l_roe_date_id and
fnd_date.canonical_to_date(fai1.value) between
fnd_date.canonical_to_date(to_char(p_start_date,'yyyy/mm/dd hh24:mi:ss')) and
fnd_date.canonical_to_date(to_char(p_end_date,'yyyy/mm/dd hh24:mi:ss')) and
fai1.context1 = fai2.context1 and
fai2.user_entity_id = l_roe_payroll_id and
fai2.value = l_payroll_id;
select 'x' from pay_action_interlocks
where locked_action_id = l_locked_action_id;