[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;
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_assignment_set_amendments hasa
,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 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 PAF.ASSIGNMENT_ID assignment_id
FROM PER_ALL_ASSIGNMENTS_F PAF,
PAY_ASSIGNMENT_ACTIONS PAA,
PAY_PAYROLL_ACTIONS PPA
WHERE PAF.payroll_id=p_payroll_id
AND PPA.PAYROLL_ACTION_ID=PAA.PAYROLL_ACTION_ID
AND PAF.ASSIGNMENT_ID=PAA.ASSIGNMENT_ID
AND PPA.EFFECTIVE_DATE BETWEEN PAF.EFFECTIVE_START_DATE AND PAF.EFFECTIVE_END_DATE
AND PPA.EFFECTIVE_DATE BETWEEN FND_DATE.CANONICAL_TO_DATE(p_start_date)
AND FND_DATE.CANONICAL_TO_DATE(p_end_date)
AND ppa.ACTION_TYPE ='X'
AND ROWNUM < 2;
SELECT PRL_INFORMATION1,PRL_INFORMATION2,PRL_INFORMATION3
FROM pay_payrolls_f
WHERE PAYROLL_ID = l_payroll_id
AND PRL_INFORMATION_CATEGORY = l_legislation_code;
SELECT SCL.segment2 local_unit_id
, business_group_id
FROM
per_all_assignments_f PAA ,
hr_soft_coding_keyflex SCL
WHERE ASSIGNMENT_ID = p_assignment_id
AND PAA.soft_coding_keyflex_id = SCL.soft_coding_keyflex_id
AND p_effective_date BETWEEN PAA.effective_start_date AND PAA.effective_end_date ;
SELECT hoi3.organization_id legal_employer_id
FROM hr_organization_units o1
, hr_organization_information hoi1
, hr_organization_information hoi2
, hr_organization_information hoi3
WHERE o1.business_group_id =p_business_group_id
AND hoi1.organization_id = o1.organization_id
AND hoi1.organization_id = p_organization_id
AND hoi1.org_information1 = 'SE_LOCAL_UNIT'
AND hoi1.org_information_context = 'CLASS'
AND o1.organization_id = hoi2.org_information1
AND hoi2.ORG_INFORMATION_CONTEXT='SE_LOCAL_UNITS'
AND hoi2.organization_id = hoi3.organization_id
AND hoi3.ORG_INFORMATION_CONTEXT='CLASS'
AND hoi3.org_information1 = 'HR_LEGAL_EMPLOYER' ;
SELECT ORG_INFORMATION1,ORG_INFORMATION2,ORG_INFORMATION3
FROM hr_organization_information
WHERE organization_id = l_legal_emp_org_id
AND org_information_context = 'SE_POST_PAYSLIP_INFO';
SELECT fnd_global.local_chr(13) || fnd_global.local_chr(10)
INTO EOL
FROM DUAL ;
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,get_parameter(ppa.legislative_parameters,c_pa_token)) = get_parameter(ppa.legislative_parameters,c_pa_token)
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;