[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
'SELECT DISTINCT ppf.person_id
FROM pay_payroll_actions ppa
,per_people_f ppf
WHERE ppa.payroll_action_id = :p_payroll_action_id
AND ppa.business_group_id = ppf.business_group_id
ORDER BY ppf.person_id';
SELECT ppa.payroll_action_id,
ppa.report_type,
ppa.report_qualifier,
ppa.report_category,
ppa.business_group_id,
ppa.effective_date,
pay_core_utils.get_parameter('BP_NP_NUMBER',ppa.legislative_parameters) -- Bug 3506172
INTO g_pact
FROM pay_payroll_actions ppa
WHERE ppa.payroll_action_id = p_payroll_action_id;
SELECT to_date('01-11-'||to_char(to_number(to_char(fnd_date.canonical_to_date(pay_core_utils.get_parameter('REPORTED_DATE',bppa.legislative_parameters)),'YYYY'))-1),'DD-MM-YYYY')
,fnd_date.canonical_to_date(pay_core_utils.get_parameter('REPORTED_DATE',bppa.legislative_parameters))
FROM pay_payroll_actions bppa
WHERE bppa.payroll_action_id = p_payroll_action_id;
SELECT distinct ass.assignment_id
,ass.establishment_id
FROM pay_payroll_actions bppa
,per_assignments_f ass
,hr_organization_information hoi
,hr_organization_units hou
WHERE bppa.payroll_action_id = p_payroll_action_id
AND ass.person_id BETWEEN p_start_person_id AND p_end_person_id
-- Bug 3506172
AND ass.establishment_id = hoi.organization_id
AND hou.business_group_id = bppa.business_group_id
AND hoi.organization_id = hou.organization_id
AND hoi.org_information_context = 'KR_NP_INFORMATION'
AND hoi.org_information1 = p_bp_np_number
-- End of 3506172
-- 3453776 : This WHERE clause has been moved from the inner SELECT
AND bppa.effective_date between ass.effective_start_date and ass.effective_end_date
--
AND EXISTS ( SELECT NULL
FROM pay_payroll_actions ppa
,pay_assignment_actions paa
WHERE ppa.payroll_action_id = paa.payroll_action_id
AND paa.assignment_id = ass.assignment_id
AND ppa.effective_date BETWEEN p_start_date
AND p_end_date
AND ppa.action_type in ('R','Q')
AND ppa.action_status = 'C'
)
AND NOT EXISTS( SELECT NULL
FROM pay_payroll_actions ppa4
,pay_assignment_actions paa4
WHERE paa4.assignment_id = ass.assignment_id
AND paa4.source_action_id IS NULL
AND paa4.payroll_action_id = ppa4.payroll_action_id
AND ppa4.action_type = 'X'
AND ppa4.report_type = 'NPA'
AND ppa4.report_qualifier = 'KR'
AND ppa4.report_category = 'A'
AND trunc(ppa4.effective_date,'YYYY') = trunc(bppa.effective_date,'YYYY')
UNION ALL -- 4660204
SELECT NULL
FROM per_people_extra_info pei
WHERE pei.person_id = ass.person_id
AND pei.information_type = 'PER_KR_NATIONAL_PENSION_INFO'
AND pei.pei_information7 IN ('03')
);
SELECT pay_assignment_actions_s.nextval
INTO l_locking_action_id
FROM dual;
SELECT fue.user_entity_id,
dbi.data_type
FROM ff_user_entities fue,
ff_database_items dbi
WHERE user_entity_name = c_user_entity_name
AND fue.user_entity_id = dbi.user_entity_id;
SELECT paa.assignment_id,
pa.payroll_id,
pa.establishment_id -- Bug 3506172
FROM per_assignments_f pa,
pay_assignment_actions paa
WHERE paa.assignment_action_id = p_assignment_action_id
AND pa.assignment_id = paa.assignment_id
AND g_pact.effective_date BETWEEN pa.effective_start_date AND pa.effective_end_date;
SELECT hoi.org_information1 business_place_code
,pp.national_identifier registration_code
,hoi.org_information2 branch_code
,hoi1.org_information14 computerization_code
FROM pay_assignment_actions paa
,per_assignments_f ass
,per_people_f pp
,hr_organization_information hoi
,hr_organization_information hoi1
WHERE paa.assignment_action_id = p_assignment_action_id
AND paa.assignment_id = ass.assignment_id
AND ass.person_id = pp.person_id
AND ass.establishment_id = hoi.organization_id
AND hoi.org_information_context = 'KR_NP_INFORMATION'
AND ass.establishment_id = hoi1.organization_id
AND hoi1.org_information_context = 'KR_BUSINESS_PLACE_REGISTRATION'
AND p_effective_date BETWEEN ass.effective_start_date AND ass.effective_end_date
AND p_effective_date BETWEEN pp.effective_start_date AND pp.effective_end_date;
l_arch_tab.delete;
SELECT meaning
FROM hr_lookups
WHERE lookup_type = p_lookup_type
AND lookup_code = p_lookup_code;