[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT per.employee_number emp_num
, SUBSTR(per.full_name,1,80) emp_name1
, SUBSTR(per.full_name,81,80) emp_name2
, SUBSTR(per.full_name,161,80) emp_name3
, hr_general.decode_lookup('IN_BANK',pea.segment3) emp_bank
, hr_general.decode_lookup('IN_BANK_BRANCH',pea.segment4) emp_branch
, hr_general.decode_lookup('IN_ACCOUNT_TYPE',pea.segment2) emp_acc_name
, pea.segment1 emp_acc_num
, ppa.legislative_parameters leg_param
, SUBSTR(lpad(paa.action_sequence,15,'0'),10) transaction_group
, ppa.request_id request_id
,oea.segment1 bank_acc_num
FROM pay_org_payment_methods_f popm
, pay_external_accounts oea
, pay_personal_payment_methods_f pppm
, pay_external_accounts pea
, pay_pre_payments ppp
, pay_assignment_actions paa
, pay_payroll_actions ppa
, per_assignments_f asg
, per_people_f per
, hr_organization_units org
, pay_payment_types ppto
WHERE ppa.payroll_action_id = l_payroll_action_id
AND paa.assignment_action_id = l_assignment_action_id
AND ppp.pre_payment_id = paa.pre_payment_id
AND paa.payroll_action_id = ppa.payroll_action_id
AND ppa.business_group_id = popm.business_group_id
AND oea.external_account_id = popm.external_account_id
AND ppa.business_group_id = org.organization_id
AND popm.org_payment_method_id = ppp.org_payment_method_id
AND pea.external_account_id = pppm.external_account_id
AND pppm.personal_payment_method_id = ppp.personal_payment_method_id
AND paa.assignment_id = asg.assignment_id
AND asg.person_id = per.person_id
AND ppa.effective_date BETWEEN popm.effective_start_date AND popm.effective_end_date
AND ppa.effective_date BETWEEN pppm.effective_start_date AND pppm.effective_end_date
AND ppa.effective_date BETWEEN asg.effective_start_date AND asg.effective_end_date
AND ppa.effective_date BETWEEN per.effective_start_date AND per.effective_end_date
AND ppto.category = 'MT'
AND popm.payment_type_id = ppto.payment_type_id
AND popm.org_payment_method_id = l_org_payment_method_id;
SELECT hoi.org_information4 company_name
FROM hr_organization_information hoi
WHERE hoi.organization_id = l_reg_company
AND hoi.org_information_context = 'PER_IN_COMPANY_DF' ;