[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT pay_fi_archive_umfr.get_parameter (
legislative_parameters,
'ARCHIVE'
)
ARCHIVE,
TO_NUMBER (
pay_fi_archive_umfr.get_parameter (
legislative_parameters,
'PAYROLL_ID'
)
)
payroll_id,
TO_NUMBER (
pay_fi_archive_umfr.get_parameter (
legislative_parameters,
'PAYROLL_ACTION_ID'
)
)
RUN_payroll_action_id,
start_date, effective_date effective_date,
business_group_id bg_id
FROM pay_payroll_actions
WHERE payroll_action_id = p_payroll_action_id;
SELECT hou.NAME, hoi.org_information1, hoi.org_information8
FROM hr_organization_information hoi, hr_organization_units hou
WHERE org_information_context = 'FI_LEGAL_EMPLOYER_DETAILS'
AND hoi.organization_id = hou.organization_id
AND hou.organization_id = csr_v_legal_employer_id;
select papf.payroll_name,ptp.end_date , ptp.period_name ,
ptp.regular_payment_date from pay_payroll_actions ppa,per_time_periods ptp,pay_all_payrolls_f papf
where ptp.time_period_id=ppa.time_period_id
and ppa.PAYROLL_ID=papf.PAYROLL_ID
and ppa.payroll_action_id=csr_v_payroll_action_id;
'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';
'select 1 from dual where to_char(:payroll_action_id) = dummy';
SELECT act.assignment_id assignment_id,
act.assignment_action_id run_action_id,
act1.assignment_action_id prepaid_action_id
FROM pay_payroll_actions appa,
pay_payroll_actions appa2,
pay_assignment_actions act,
pay_assignment_actions act1,
pay_action_interlocks pai,
per_all_assignments_f paaf
WHERE appa.payroll_action_id=p_run_payroll_action_id
AND appa.action_type IN ('R', 'Q')
AND act.payroll_action_id = appa.payroll_action_id
AND act.source_action_id IS NULL -- Master Action
AND act.action_status = 'C' -- Completed
AND act.assignment_action_id = pai.locked_action_id
AND act1.assignment_action_id = pai.locking_action_id
AND act1.action_status = 'C' -- Completed
AND act1.payroll_action_id = appa2.payroll_action_id
AND appa2.action_type IN ('P', 'U')
and paaf.assignment_id=act.assignment_id
and paaf.person_id BETWEEN p_start_person
AND p_end_person ;
SELECT pay_assignment_actions_s.NEXTVAL
INTO l_actid
FROM DUAL;
SELECT Distinct(pap.full_name) NAME,
PAA.ASSIGNMENT_NUMBER ASSIGNMENT_NUMBER,
-- pap.national_identifier national_identifier,
paa.assignment_id assignment_id
FROM per_all_people_f pap,
per_all_assignments_f paa,
pay_assignment_actions pasa
WHERE paa.person_id = pap.person_id
AND pasa.assignment_id = paa.assignment_id
AND pap.business_group_id = csr_v_business_group_id
-- AND g_pay_period_end_date BETWEEN pap.effective_start_date
-- AND pap.effective_end_date
-- AND g_pay_period_end_date BETWEEN paa.effective_start_date
-- AND paa.effective_end_date
AND pasa.assignment_action_id = p_assignment_action_id;
SELECT 1
INTO l_flag
FROM pay_action_information
WHERE action_information_category = 'EMEA REPORT INFORMATION'
AND action_information1 = 'PYFIUMFR'
AND action_information2 = 'PER'
AND action_context_id = p_assignment_action_id;
SELECT defined_balance_id
FROM pay_balance_types pbt,
pay_balance_dimensions pbd,
pay_defined_balances pdb
WHERE pbt.balance_name = csr_v_balance_name
AND pbt.legislation_code = 'FI'
AND pbt.balance_type_id = pdb.balance_type_id
AND pbd.database_item_suffix = '_ASG_PTD'
AND pbd.legislation_code = 'FI'
AND pbd.balance_dimension_id = pdb.balance_dimension_id
and pdb.legislation_code = 'FI';
SELECT paa_run.assignment_action_id
FROM pay_assignment_actions paa_archive, pay_assignment_actions paa_run
WHERE paa_run.assignment_id = paa_archive.assignment_id
AND paa_run.payroll_action_id = g_run_payroll_action_id
AND paa_archive.assignment_action_id = p_assignment_action_id;
/* SELECT ue.creator_id
FROM ff_user_entities ue, ff_database_items di
WHERE di.user_name = csr_v_balance_name
AND ue.user_entity_id = di.user_entity_id
AND ue.legislation_code = 'FI';