[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT org_information10
FROM hr_organization_information
WHERE organization_id = p_business_group_id
AND org_information_context = 'Business Group Information';
select meaning
from hr_lookups
where lookup_type = p_lookup_type
and lookup_code = p_lookup_code;
SELECT nvl(date_earned,effective_date)
FROM pay_payroll_actions
WHERE payroll_action_id = l_pact_id;
SELECT payroll_name
FROM pay_all_payrolls_f pap, pay_payroll_actions ppa
WHERE ppa.payroll_action_id = l_pact_id
AND ppa.payroll_id = pap.payroll_id;
select paa.assignment_action_id , paa.assignment_id
from pay_assignment_actions paa , per_all_assignments_f paf, hr_all_organization_units hou
where paa.payroll_action_id = p_pact_id
and paa.action_status = 'C'
and not exists ( select 1
from pay_assignment_actions paa1, pay_payroll_actions ppa1, pay_action_interlocks lck
where lck.locked_action_id = paa.assignment_action_id
and lck.locking_action_id = paa1.assignment_action_id
and ppa1.payroll_action_id = paa1.payroll_action_id
and ppa1.action_type = 'D'
and ppa1.action_status = 'C'
and paa1.action_status = 'C')
and paa.assignment_id = paf.assignment_id
and trunc(l_date,'MM') between trunc(paf.effective_start_date,'MM') and paf.effective_end_date
and paf.organization_id = hou.organization_id
and trunc(l_date,'MM') between trunc(hou.date_from,'MM') and nvl(hou.date_to, to_date('31/12/4712','DD/MM/YYYY'))
order by hou.name;
select paa.assignment_action_id , paa.assignment_id
from pay_assignment_actions paa , per_all_assignments_f paf, hr_all_organization_units hou, per_all_people_f ppf
where paa.payroll_action_id = p_pact_id
and paa.action_status = 'C'
and not exists ( select 1
from pay_assignment_actions paa1, pay_payroll_actions ppa1, pay_action_interlocks lck
where lck.locked_action_id = paa.assignment_action_id
and lck.locking_action_id = paa1.assignment_action_id
and ppa1.payroll_action_id = paa1.payroll_action_id
and ppa1.action_type = 'D'
and ppa1.action_status = 'C'
and paa1.action_status = 'C')
and paa.assignment_id = paf.assignment_id
and trunc(l_date,'MM') between trunc(paf.effective_start_date,'MM') and paf.effective_end_date
and paf.person_id = ppf.person_id
and trunc(l_date,'MM') between trunc(ppf.effective_start_date,'MM') and ppf.effective_end_date
and paf.organization_id = hou.organization_id
and trunc(l_date,'MM') between trunc(hou.date_from,'MM') and nvl(hou.date_to, to_date('31/12/4712','DD/MM/YYYY'))
order by hou.name, ppf.full_name;
select paa.assignment_action_id , paa.assignment_id
from pay_assignment_actions paa , per_all_assignments_f paf, per_all_people_f ppf
where paa.payroll_action_id = p_pact_id
and paa.action_status = 'C'
and not exists ( select 1
from pay_assignment_actions paa1, pay_payroll_actions ppa1, pay_action_interlocks lck
where lck.locked_action_id = paa.assignment_action_id
and lck.locking_action_id = paa1.assignment_action_id
and ppa1.payroll_action_id = paa1.payroll_action_id
and ppa1.action_type = 'D'
and ppa1.action_status = 'C'
and paa1.action_status = 'C')
and paa.assignment_id = paf.assignment_id
and trunc(l_date,'MM') between trunc(paf.effective_start_date,'MM') and paf.effective_end_date
and paf.person_id = ppf.person_id
and trunc(l_date,'MM') between trunc(ppf.effective_start_date,'MM') and ppf.effective_end_date
order by ppf.employee_number;
select paa.assignment_action_id , paa.assignment_id
from pay_assignment_actions paa , pay_payroll_actions ppa , pay_pre_payments ppp , pay_assignment_actions paa1
where paa.payroll_action_id = p_pact_id
and paa.action_status = 'C'
and not exists ( select 1
from pay_assignment_actions paa1, pay_payroll_actions ppa1, pay_action_interlocks lck
where lck.locked_action_id = paa.assignment_action_id
and lck.locking_action_id = paa1.assignment_action_id
and ppa1.payroll_action_id = paa1.payroll_action_id
and ppa1.action_type = 'D'
and ppa1.action_status = 'C'
and paa1.action_status = 'C')
and paa.pre_payment_id = ppp.pre_payment_id
and ppp.assignment_action_id = paa1.assignment_action_id
and paa1.action_status = 'C'
and ppa.payroll_action_id = paa1.payroll_action_id
and ppa.action_status = 'C'
and ppa.action_type in ('P','U')
order by nvl(ppa.date_earned,ppa.effective_date);
select paa.assignment_action_id , paa.assignment_id
from pay_assignment_actions paa , pay_payroll_actions ppa , pay_pre_payments ppp , pay_assignment_actions paa1,
per_all_people_f ppf, per_all_assignments_f paf
where paa.payroll_action_id = p_pact_id
and paa.action_status IN ('C','S') -- 10375683
and not exists ( select 1
from pay_assignment_actions paa1, pay_payroll_actions ppa1, pay_action_interlocks lck
where lck.locked_action_id = paa.assignment_action_id
and lck.locking_action_id = paa1.assignment_action_id
and ppa1.payroll_action_id = paa1.payroll_action_id
and ppa1.action_type = 'D'
and ppa1.action_status = 'C'
and paa1.action_status = 'C')
and paa.pre_payment_id = ppp.pre_payment_id
and ppp.assignment_action_id = paa1.assignment_action_id
and paa1.action_status IN ('C','S') --10375683
and ppa.payroll_action_id = paa1.payroll_action_id
and ppa.action_status = 'C'
and ppa.action_type in ('P','U')
and paa.assignment_id = paf.assignment_id
and trunc(l_date,'MM') between trunc(paf.effective_start_date,'MM') and paf.effective_end_date
and paf.person_id = ppf.person_id
and trunc(l_date,'MM') between trunc(ppf.effective_start_date,'MM') and ppf.effective_end_date
order by nvl(ppa.date_earned,ppa.effective_date),ppf.full_name;
SELECT ppf.full_name , ppf.employee_number , paf.job_id , paf.organization_id
FROM per_all_people_f ppf, per_all_assignments_f paf
WHERE paf.assignment_id = l_assignment_id
AND paf.person_id = ppf.person_id
AND trunc(l_date,'MM') between trunc(paf.effective_start_date,'MM') and paf.effective_end_date
AND trunc(l_date,'MM') between trunc(ppf.effective_start_date,'MM') and ppf.effective_end_date;
SELECT serial_number, value
FROM pay_pre_payments_v2 pv2
WHERE pv2.business_group_id+0 = p_business_group_id
AND pv2.assignment_action_id = l_assact_id
AND pv2.pre_payment_id in (select ppp.pre_payment_id
from pay_pre_payments ppp,pay_action_interlocks lck , pay_org_payment_methods_f org ,
pay_payment_types pt,pay_assignment_actions paa1
where lck.locking_action_id = l_assact_id
and lck.locked_action_id = ppp.assignment_action_id
and paa1.assignment_action_id = lck.locking_action_id
and paa1.pre_payment_id = ppp.pre_payment_id
and paa1.action_status = 'C'
and ppp.org_payment_method_id = org.org_payment_method_id
and org.payment_type_id = pt.payment_type_id
and pt.category = 'CH')
AND trunc(l_date ,'MM') between trunc(opm_effective_start_date,'MM') and opm_effective_end_date;
SELECT name
FROM per_jobs
WHERE job_id = l_job
AND trunc(l_date,'MM') between date_from and nvl(date_to, to_date('31/12/4712','DD/MM/YYYY'));
SELECT name
FROM hr_all_organization_units
WHERE organization_id = l_org_id
AND trunc(l_date,'MM') between date_from and nvl(date_to, to_date('31/12/4712','DD/MM/YYYY'));
select nvl(ppa.date_earned,ppa.effective_date)
from pay_payroll_actions ppa, pay_assignment_actions paa, pay_pre_payments ppp, pay_assignment_actions paa1
where paa.assignment_action_id = l_assact_id
and paa.action_status IN ('C','S') --10375683
and paa.pre_payment_id = ppp.pre_payment_id
and ppp.assignment_action_id = paa1.assignment_action_id
and paa1.action_status IN ('C','S') --10375683
and paa1.payroll_action_id = ppa.payroll_action_id
and ppa.action_type in ('P','U')
and ppa.action_status = 'C';
INSERT INTO fnd_sessions (session_id, effective_date)
VALUES (userenv('sessionid'), l_effective_date);
vXMLTable.DELETE;
select userenv('LANGUAGE') into g_nls_db_char from dual;
Select file_data
Into p_pdf_blob
From fnd_lobs
Where file_id = (select max(file_id) from fnd_lobs where file_name like '%PAY_CHQ_ar_KW.rtf');