[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
l_string := 'SELECT pad.'||p_column_name ;
l_string := 'SELECT NVL(pdd.'||p_column_name||', ''0'') ';
SELECT pas.treaty_honored_flag
FROM pqp_alien_state_treaties_f pas
WHERE l_effective_date BETWEEN
pas.effective_start_date AND pas.effective_end_date
AND pas.state_code = l_state_code;
SELECT state_code
FROM pay_state_rules
WHERE substr(jurisdiction_code,1,2) = substr(p_ele_iv_jur_code,1,2);
l_string := 'SELECT 1
FROM pqp_analyzed_alien_data pad,
pqp_analyzed_alien_details pdd
WHERE pad.assignment_id = :b1
AND to_char(:b2,''yyyy'') = pad.tax_year
AND pad.analyzed_data_id = pdd.analyzed_data_id
AND :b2 BETWEEN NVL(treaty_benefits_start_date,:b2)
AND NVL(date_benefit_ends, :b2)
AND pdd.income_code = :b3
AND rownum < 2';
SELECT meaning
FROM hr_lookups
WHERE lookup_code = p_income_code
AND lookup_type = 'PQP_US_ALIEN_INCOME_BALANCE';
SELECT pdb.defined_balance_id
FROM pay_balance_types pbt,
pay_defined_balances pdb,
pay_balance_dimensions pbd
WHERE pbt.balance_name = l_bal_name
AND pbt.balance_type_id = pdb.balance_type_id
AND pbd.balance_dimension_id = pdb.balance_dimension_id
AND pbd.dimension_name = l_dim_name
AND NVL(pbd.legislation_code,'US') = 'US';
SELECT SFT.segment1
FROM hr_soft_coding_keyflex SFT,
per_assignments_f ASG
WHERE SFT.soft_coding_keyflex_id = ASG.soft_coding_keyflex_id
AND ASG.assignment_id = p_assignment_id;
SELECT jurisdiction_code
FROM pay_state_rules
WHERE state_code = p_state_code;
SELECT 'x'
FROM per_people_extra_info PEI
WHERE PEI.information_type = 'PER_US_ADDITIONAL_DETAILS'
AND PEI.pei_information12 = 'WINDSTAR'
AND PEI.person_id = p_person_id;
SELECT 'x'
FROM per_people_extra_info PEI,
per_all_assignments_f PAA
WHERE PEI.information_type = 'PER_US_ADDITIONAL_DETAILS'
AND PEI.pei_information12 = 'WINDSTAR'
AND PEI.person_id = PAA.person_id
AND PAA.assignment_id = p_assignment_id;
SELECT defined_balance_id
FROM pay_defined_balances pdb,
pay_balance_types pbt,
pay_balance_dimensions pbd
WHERE pdb.balance_type_id = pbt.balance_type_id
AND pdb.balance_dimension_id = pbd.balance_dimension_id
AND pbt.balance_name = c_balance_name
AND pbd.dimension_name = c_dimension_name
AND nvl(pdb.legislation_code, 'US') = 'US';
SELECT DECODE (upper(p_period),
'CURRENT','Assignment-Level Current Run',
'RUN','Assignment within Government Reporting Entity Run',
'PAY','Assignment within Government Reporting Entity Pay Date',
'MONTH','Assignment within Government Reporting Entity Month',
'QTD','Assignment within Government Reporting Entity Quarter to Date',
'YTD','Assignment within Government Reporting Entity Year to Date',null)
INTO l_dimension_name
FROM DUAL;
SELECT DECODE (upper(p_period),
'RUN','Assignment in JD within GRE Run',
'MONTH','Assignment in JD within GRE Month',
'QTD','Assignment in JD within GRE Quarter to Date',
'YTD','Assignment in JD within GRE Year to Date',null)
INTO l_dimension_name
FROM DUAL;
SELECT pei.pei_information6
FROM per_people_extra_info pei
WHERE pei.pei_information7 = to_char(l_effective_date,'YYYY')
AND pei.pei_information5 = p_income_code
AND pei.information_type = 'PER_US_PAYROLL_DETAILS'
AND person_id IN
(SELECT pas.person_id
FROM per_all_assignments_f pas
WHERE pas.assignment_id = p_assignment_id
AND l_effective_date BETWEEN pas.effective_start_date
AND pas.effective_end_date);
SELECT ppe.process_event_id
FROM pay_process_events ppe
WHERE ppe.assignment_id = p_assignment_id
AND ppe.change_type = 'PQP_US_ALIEN_WINDSTAR'
AND ppe.status IN ('N','D','R'); --+ Not read,Read,Data validation error
SELECT 'x'
FROM pay_element_entries_f pee
,pay_element_links_f pel
,pay_element_types_f pet
,pay_element_classifications pec
WHERE pee.assignment_id = p_assignment_id
AND pee.element_link_id = pel.element_link_id
AND pel.element_type_id = pet.element_type_id
AND pet.classification_id = pec.classification_id
AND pec.classification_name = 'Alien/Expat Earnings'
AND pec.legislation_code = 'US'
AND p_effective_date BETWEEN pee.effective_start_date
AND pee.effective_end_date
AND p_effective_date BETWEEN pel.effective_start_date
AND pel.effective_end_date
AND p_effective_date BETWEEN pet.effective_start_date
AND pet.effective_end_date;
SELECT 'x'
FROM pay_element_entries_f pee
,pay_element_links_f pel
,pay_element_types_f pet
WHERE pee.assignment_id = p_assignment_id
AND pee.element_link_id = pel.element_link_id
AND pel.element_type_id = pet.element_type_id
AND pet.element_name = 'ALIEN_TAXATION'
AND p_effective_date BETWEEN pee.effective_start_date
AND pee.effective_end_date
AND p_effective_date BETWEEN pel.effective_start_date
AND pel.effective_end_date
AND p_effective_date BETWEEN pet.effective_start_date
AND pet.effective_end_date;
SELECT dbl.defined_balance_id
FROM pay_defined_balances dbl
WHERE dbl.balance_type_id =
(SELECT balance_type_id
FROM pay_balance_types blt
WHERE blt.balance_name = p_bal_name
AND blt.legislation_code = 'US')
AND dbl.balance_dimension_id =
(SELECT balance_dimension_id
FROM pay_balance_dimensions bld
WHERE bld.database_item_suffix =
'_'|| p_dimension
AND bld.legislation_code = 'US')
AND dbl.legislation_code = 'US';