[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT get_parameter(ppa.legislative_parameters,'PAYROLL_ID')
,get_parameter(ppa.legislative_parameters,'CONSOLIDATION_SET_ID')
,get_parameter(ppa.legislative_parameters,'START_DATE')
,get_parameter(ppa.legislative_parameters,'END_DATE')
,get_parameter(ppa.legislative_parameters,'REP_GROUP')
,get_parameter(ppa.legislative_parameters,'REP_CAT')
,get_parameter(ppa.legislative_parameters,'ASSIGNMENT_SET_ID')
,get_parameter(ppa.legislative_parameters,'ASSIGNMENT_ID')
,ppa.effective_date
,ppa.business_group_id
,pbg.legislation_code
FROM pay_payroll_actions ppa
,per_business_groups pbg
WHERE ppa.payroll_action_id = c_payroll_action_id
AND ppa.business_group_id = pbg.business_group_id;
EXECUTE IMMEDIATE 'SELECT pay_'||p_legislation_code||'_rules.get_payslip_sort_order1 FROM DUAL'
INTO l_sort_order;
EXECUTE IMMEDIATE 'SELECT pay_'||p_legislation_code||'_rules.get_payslip_sort_order2 FROM DUAL'
INTO l_sort_order;
EXECUTE IMMEDIATE 'SELECT pay_'||p_legislation_code||'_rules.get_payslip_sort_order3 FROM DUAL'
INTO l_sort_order;
SELECT 'Y'
FROM pay_assignment_actions paa
,pay_payroll_actions ppa
,hr_lookups hrl
,pay_action_information pai
,per_time_periods ptp
WHERE paa.assignment_id = c_assignment_id
AND paa.payroll_action_id = ppa.payroll_action_id
AND paa.source_action_id IS NULL
AND ppa.effective_Date BETWEEN c_start_date
AND c_end_date
AND ppa.report_type = hrl.meaning
AND hrl.lookup_type = 'PAYSLIP_REPORT_TYPES'
AND hrl.lookup_code = c_legislation_code
AND NVL(c_payroll_id,NVL(get_parameter(ppa.legislative_parameters,c_pa_token),-1))
= NVL(get_parameter(ppa.legislative_parameters,c_pa_token),-1)
AND c_consolidation_set_id = get_parameter(ppa.legislative_parameters,c_cs_token)
AND pai.assignment_id = paa.assignment_id
AND pai.action_context_type = 'AAP'
AND pai.action_information_category = 'EMPLOYEE DETAILS'
AND pai.action_context_id = paa.assignment_action_id
AND ptp.time_period_id = pai.ACTION_INFORMATION16
AND pay_us_employee_payslip_web.check_emp_personal_payment
( paa.assignment_id, ptp.payroll_id, pai.action_information16,
pai.action_context_id, pai.effective_date) = 'Y' ;
SELECT 'Y'
FROM pay_assignment_actions paa
,pay_payroll_actions ppa
,hr_lookups hrl
,hr_assignment_set_amendments hasa
,pay_action_information pai
,per_time_periods ptp
WHERE paa.assignment_id = c_assignment_id
AND paa.payroll_action_id = ppa.payroll_action_id
AND paa.source_action_id IS NULL
AND ppa.effective_Date BETWEEN c_start_date
AND c_end_date
AND ppa.report_type = hrl.meaning
AND hrl.lookup_type = 'PAYSLIP_REPORT_TYPES'
AND hrl.lookup_code = c_legislation_code
AND NVL(c_payroll_id,NVL(get_parameter(ppa.legislative_parameters,c_pa_token),-1))
= NVL(get_parameter(ppa.legislative_parameters,c_pa_token),-1)
AND c_consolidation_set_id = get_parameter(ppa.legislative_parameters,c_cs_token)
AND paa.assignment_id = hasa.assignment_id
AND hasa.assignment_set_id = c_assignment_set_id
AND hasa.include_or_exclude = 'I'
AND pai.assignment_id = paa.assignment_id
AND pai.action_context_type = 'AAP'
AND pai.action_information_category = 'EMPLOYEE DETAILS'
AND pai.action_context_id = paa.assignment_action_id
AND ptp.time_period_id = pai.ACTION_INFORMATION16
AND pay_us_employee_payslip_web.check_emp_personal_payment
( paa.assignment_id, ptp.payroll_id, pai.action_information16,
pai.action_context_id, pai.effective_date) = 'Y' ;
SELECT include_or_exclude
FROM hr_assignment_set_amendments
WHERE assignment_set_id = c_assignment_set_id
AND assignment_id = nvl(c_assignment_id,assignment_id);
SELECT pai.action_context_id
FROM pay_temp_object_actions ptoa
,pay_action_information pai
,pay_assignment_Actions paa
,pay_payroll_actions ppa
,hr_lookups hrl
WHERE ptoa.object_Action_id = pay_magtape_generic.get_parameter_value('TRANSFER_ACT_ID')
AND ptoa.object_id = paa.assignment_id
AND paa.payroll_action_id = ppa.payroll_action_id
AND ppa.effective_Date BETWEEN c_start_date
AND c_end_date
AND ppa.report_type = hrl.meaning--'ES_PS_ARCHIVE'
AND hrl.lookup_type = 'PAYSLIP_REPORT_TYPES'
AND hrl.lookup_code = c_legislation_code
AND NVL(c_payroll_id,NVL(get_parameter(ppa.legislative_parameters,c_pa_token),-1))
= NVL(get_parameter(ppa.legislative_parameters,c_pa_token),-1)
AND c_consolidation_set_id = get_parameter(ppa.legislative_parameters,c_cs_token)
AND pai.assignment_id = paa.assignment_id
AND pai.action_context_type = 'AAP'
AND pai.action_information_category = 'EMPLOYEE DETAILS'
AND pai.action_context_id = paa.assignment_action_id;