[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
sqlstr := 'SELECT DISTINCT person_id
FROM per_people_f ppf
,pay_payroll_actions ppa
WHERE ppa.payroll_action_id = :payroll_action_id
AND ppa.business_group_id = ppf.business_group_id
ORDER BY ppf.person_id';
sqlstr := 'select 1 from dual where to_char(:payroll_action_id) = dummy';
select /*+leading(asg_run) index(asg_run PER_ASSIGNMENTS_F_N12)
index(org_est HR_ORGANIZATION_INFORMATIO_FK2)
index(org_coy HR_ORGANIZATION_INFORMATIO_FK2) */
ppa_run.payroll_id, asg_run.assignment_id,
max(nvl(paa_run.source_action_id
,paa_run.assignment_action_id)) mst_action_id
from pay_assignment_Actions paa_run
,pay_payroll_actions ppa_run
,per_all_assignments_f asg_run
,hr_organization_information org_est
,hr_organization_information org_coy
where ppa_run.business_group_id = asg_run.business_group_id
and asg_run.business_group_id = g_param_business_group_id
and ppa_run.payroll_action_id = paa_run.payroll_Action_id
and ppa_run.action_type in ('R','Q')
and ppa_run.action_status = 'C'
and paa_run.action_status = 'C'
and ppa_run.effective_Date between g_param_start_date
and g_param_effective_date
and paa_run.assignment_id = asg_run.assignment_id
and ppa_run.effective_date BETWEEN asg_run.effective_start_date
AND asg_run.effective_end_date
and asg_run.person_id BETWEEN stperson
AND endperson
and (paa_run.source_action_id is null or paa_run.end_date is not null)
/* the estab parameter condition is met */
and paa_run.tax_unit_id = nvl(g_param_estab_id, paa_run.tax_unit_id)
/* the company parameter condition is met */
and org_est.organization_id = paa_run.tax_unit_id
and org_est.org_information_context = 'FR_ESTAB_INFO'
and org_coy.organization_id+0 = nvl(g_param_company_id /*comp param*/
,org_coy.organization_id)
/* the estab's coy has the parameterized issueing estab */
and org_est.org_information1 = org_coy.organization_id
and org_coy.org_information_context = 'FR_COMP_INFO'
and org_coy.org_information4 = g_param_issuing_estab_id
group by ppa_run.payroll_id, asg_run.assignment_id;
SELECT pay_assignment_actions_s.NEXTVAL
INTO l_actid
FROM dual;
select distinct hoi.organization_id organization_id
from hr_organization_information hoi,
hr_organization_information hoi_issue
where hoi.org_information_context = 'CLASS'
and hoi.org_information1 = 'FR_SOCIETE'
and hoi_issue.organization_id = hoi.organization_id
and hoi_issue.org_information_context = 'FR_COMP_INFO'
and hoi_issue.org_information4 = g_param_issuing_estab_id;
SELECT pay_fr_dads_pkg.get_parameter(legislative_parameters, 'ISSUING_ESTAB_ID')
,pay_fr_dads_pkg.get_parameter(legislative_parameters, 'COMPANY_ID')
,pay_fr_dads_pkg.get_parameter(legislative_parameters, 'ESTAB_ID')
,business_group_id
,pay_fr_dads_pkg.get_parameter(legislative_parameters, 'REFERENCE')
,start_date
,effective_date
FROM pay_payroll_actions
WHERE payroll_action_id = p_payroll_action_id;
select distinct hoi.organization_id
from hr_organization_information hoi,
hr_organization_information hoi_issue
where hoi.org_information_context ||'' = 'CLASS'
and hoi.org_information1 = 'FR_SOCIETE'
and hoi_issue.organization_id =hoi.organization_id
and hoi_issue.org_information_context = 'FR_COMP_INFO'
and hoi_issue.org_information4 = g_param_issuing_estab_id;
select distinct pacinfo.action_information7 estab_id
from pay_action_information pacinfo,
pay_assignment_actions pasac
where pacinfo.action_context_id = pasac.assignment_action_id
and pasac.payroll_action_id = p_payroll_action_id
and pacinfo.action_information_category = 'FR_DADS_FILE_DATA'
and pacinfo.action_information1 = 'S41.G01.00.005';