[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT input_value_id
,default_value
,lookup_type
,value_set_id
FROM pay_input_values_f
WHERE element_type_id = p_element_type_id
AND UPPER(name) = UPPER(p_input_value_name_in_caps)
AND p_effective_date
BETWEEN effective_start_date
AND effective_end_date;
SELECT eev.screen_entry_value
,liv.default_value
FROM pay_element_entries_f ele
,pay_element_links_f lnk
,pay_link_input_values_f liv
,pay_element_entry_values_f eev
WHERE ele.assignment_id = p_assignment_id
AND ele.entry_type = 'E'
AND p_effective_date
BETWEEN ele.effective_start_date
AND ele.effective_end_date
AND eev.element_entry_id = ele.element_entry_id
AND lnk.element_link_id = ele.element_link_id
AND lnk.element_type_id = p_element_type_id
AND p_effective_date
BETWEEN eev.effective_start_date
AND eev.effective_end_date
AND eev.input_value_id = p_input_value_id
AND liv.element_link_id = lnk.element_link_id
AND liv.input_value_id = p_input_value_id
AND p_effective_date
BETWEEN liv.effective_start_date
AND liv.effective_end_date
AND p_effective_date
BETWEEN lnk.effective_start_date
AND lnk.effective_end_date;
SELECT pee.element_entry_id
FROM pay_element_links_f pel
,pay_element_entries_f pee
WHERE pel.element_type_id = p_element_type_id
AND p_effective_date
BETWEEN pel.effective_start_date
AND pel.effective_end_date
AND pee.element_link_id = pel.element_link_id
AND pee.assignment_id = p_assignment_id
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;
SELECT eev.screen_entry_value
,liv.default_value
FROM pay_element_entries_f ele
,pay_element_links_f lnk
,pay_link_input_values_f liv
,pay_element_entry_values_f eev
WHERE ele.element_entry_id = p_element_entry_id
AND p_effective_date
BETWEEN ele.effective_start_date
AND ele.effective_end_date
AND eev.element_entry_id = ele.element_entry_id
AND lnk.element_link_id = ele.element_link_id
AND lnk.element_type_id = ele.element_type_id
AND p_effective_date
BETWEEN eev.effective_start_date
AND eev.effective_end_date
AND eev.input_value_id = p_input_value_id
AND liv.element_link_id = lnk.element_link_id
AND liv.input_value_id = p_input_value_id
AND p_effective_date
BETWEEN liv.effective_start_date
AND liv.effective_end_date
AND p_effective_date
BETWEEN lnk.effective_start_date
AND lnk.effective_end_date;
SELECT business_group_id
FROM per_all_assignments_f
WHERE assignment_id = p_assignment_id;
SELECT pei.eei_information1 from_time_dimension
,pei.eei_information2 pay_source_value
,pei.eei_information3 qualifier
,pei.eei_information4 fte
,pei.eei_information5 termtime
,pei.eei_information7 calc_type
,pei.eei_information8 calc_value
,pei.eei_information9 input_value
,NVL(pei.eei_information10
,decode(pei.eei_information2,'IV','Y','N')) link_to_assign
,NVL(pei.eei_information12,'Y') term_time_yes_no -- ! be careful
,NVL(pei.eei_information13,'N') sum_multiple_entries_yn
,NVL(pei.eei_information14,'N') lookup_input_values_yn
,pei.eei_information16 column_name_source_type
,pei.eei_information17 column_name_source_name
,pei.eei_information18 row_name_source_type
,pei.eei_information19 row_name_source_name
FROM pay_element_type_extra_info pei
WHERE pei.element_type_extra_info_id = p_element_type_extra_info_id;
SELECT sci.VALUE
,lci.VALUE
,uci.VALUE
FROM pay_user_column_instances_f sci
,pay_user_columns sc
,pay_user_column_instances_f uci
,pay_user_columns uc
,pay_user_column_instances_f lci
,pay_user_columns lc
,pay_user_tables ut
,pay_user_rows_f ur
WHERE ut.user_table_name = 'PQP_CONTRACT_TYPES'
AND ur.user_table_id = ut.user_table_id
AND UPPER(ur.row_low_range_or_name) = UPPER(p_contract_type)
AND UPPER(sc.user_column_name) =
UPPER(p_column_name || ' ADJUSTMENT FACTOR')
AND sc.user_table_id = ut.user_table_id
AND sci.user_column_id = sc.user_column_id
AND ur.user_row_id = sci.user_row_id
AND UPPER(uc.user_column_name) =
UPPER(p_column_name || ' UPPER LIMIT')
AND uc.user_table_id = ut.user_table_id
AND uci.user_column_id = uc.user_column_id
AND ur.user_row_id = uci.user_row_id
AND UPPER(lc.user_column_name) =
UPPER(p_column_name || ' LOWER LIMIT')
AND lc.user_table_id = ut.user_table_id
AND lci.user_column_id = lc.user_column_id
AND ur.user_row_id = lci.user_row_id
AND (
(
sci.business_group_id IS NOT NULL
AND sci.business_group_id = l_business_group_id
)
OR (
sci.legislation_code IS NOT NULL
AND sci.business_group_id IS NULL
)
OR (
sci.business_group_id IS NULL
AND sci.legislation_code IS NULL
)
)
AND (
(
uci.business_group_id IS NOT NULL
AND uci.business_group_id = l_business_group_id
)
OR (
uci.legislation_code IS NOT NULL
AND uci.business_group_id IS NULL
)
OR (
uci.business_group_id IS NULL
AND uci.legislation_code IS NULL
)
)
AND (
(
lci.business_group_id IS NOT NULL
AND lci.business_group_id = l_business_group_id
)
OR (
lci.legislation_code IS NOT NULL
AND lci.business_group_id IS NULL
)
OR (
lci.business_group_id IS NULL
AND lci.legislation_code IS NULL
)
)
AND (
(
ur.business_group_id IS NOT NULL
AND ur.business_group_id = l_business_group_id
)
OR (
ur.legislation_code IS NOT NULL
AND ur.business_group_id IS NULL
)
OR (
ur.business_group_id IS NULL AND ur.legislation_code IS NULL
)
)
AND p_date BETWEEN ur.effective_start_date AND ur.effective_end_date
AND p_date BETWEEN sci.effective_start_date AND sci.effective_end_date
AND p_date BETWEEN uci.effective_start_date AND uci.effective_end_date
AND p_date BETWEEN lci.effective_start_date AND lci.effective_end_date;
SELECT contract_type
FROM pqp_assignment_attributes_f
WHERE assignment_id = p_assignment_id
AND p_date BETWEEN effective_start_date AND effective_end_date;
SELECT types.number_per_fiscal_year annualization_factor
FROM per_all_assignments_f assign
,per_time_periods period
,per_time_period_types types
WHERE assign.assignment_id = p_assignment_id
AND period.payroll_id = assign.payroll_id
AND p_effective_date BETWEEN period.start_date
AND period.end_date
AND types.period_type = period.period_type
AND p_effective_date BETWEEN assign.effective_start_date
AND assign.effective_end_date;
SELECT number_per_fiscal_year
FROM per_time_period_types
WHERE period_type = p_period_type;
SELECT contract_type
FROM pqp_assignment_attributes_f
WHERE assignment_id = p_assignment_id
AND p_date BETWEEN effective_start_date
AND effective_end_date;
SELECT TO_NUMBER(pgr.VALUE)
FROM pay_grade_rules_f pgr
,pay_rates pr
,per_spinal_point_placements_f spp
,per_spinal_point_steps_f sps
WHERE spp.assignment_id = p_assignment_id
AND UPPER(pr.NAME) = UPPER(p_qualifier)
AND pgr.rate_type = 'SP'
AND pr.rate_type = 'SP'
AND pgr.business_group_id = l_business_group_id
AND pr.business_group_id = l_business_group_id
AND spp.business_group_id = l_business_group_id
AND sps.business_group_id = l_business_group_id
AND pgr.rate_id = pr.rate_id
AND spp.step_id = sps.step_id
AND sps.spinal_point_id = pgr.grade_or_spinal_point_id
AND p_date BETWEEN spp.effective_start_date AND spp.effective_end_date
AND p_date BETWEEN sps.effective_start_date AND sps.effective_end_date
AND p_date BETWEEN pgr.effective_start_date AND pgr.effective_end_date;
SELECT TO_NUMBER(pgr.VALUE)
FROM pay_grade_rules_f pgr
,pay_rates pr
,per_spinal_point_placements_f spp
,per_spinal_point_steps_f sps
WHERE spp.assignment_id = p_assignment_id
AND UPPER(pr.NAME) LIKE UPPER(p_qualifier)
AND pgr.rate_type = 'SP'
AND pr.rate_type = 'SP'
AND pgr.business_group_id = l_business_group_id
AND pr.business_group_id = l_business_group_id
AND spp.business_group_id = l_business_group_id
AND sps.business_group_id = l_business_group_id
AND pgr.rate_id = pr.rate_id
AND spp.step_id = sps.step_id
AND sps.spinal_point_id = pgr.grade_or_spinal_point_id
AND p_date BETWEEN spp.effective_start_date AND spp.effective_end_date
AND p_date BETWEEN sps.effective_start_date AND sps.effective_end_date
AND p_date BETWEEN pgr.effective_start_date AND pgr.effective_end_date
ORDER BY pgr.effective_start_date DESC;
SELECT TO_NUMBER(pgr.VALUE)
FROM per_assignments_f paf, pay_grade_rules_f pgr, pay_rates pr
WHERE paf.assignment_id = p_assignment_id
AND paf.grade_id = pgr.grade_or_spinal_point_id
AND pgr.rate_type = 'G'
AND pgr.rate_id = pr.rate_id
AND pr.rate_type = 'G'
AND paf.business_group_id = l_business_group_id
AND pr.business_group_id = l_business_group_id
AND pr.business_group_id = l_business_group_id
AND UPPER(pr.NAME) = UPPER(p_qualifier)
AND p_date BETWEEN paf.effective_start_date AND paf.effective_end_date
AND p_date BETWEEN pgr.effective_start_date AND pgr.effective_end_date;
SELECT TO_NUMBER(pgr.VALUE)
FROM per_assignments_f paf, pay_grade_rules_f pgr, pay_rates pr
WHERE paf.assignment_id = p_assignment_id
AND paf.grade_id = pgr.grade_or_spinal_point_id
AND pgr.rate_type = 'G'
AND pgr.rate_id = pr.rate_id
AND pr.rate_type = 'G'
AND paf.business_group_id = l_business_group_id
AND pr.business_group_id = l_business_group_id
AND pr.business_group_id = l_business_group_id
AND UPPER(pr.NAME) LIKE UPPER(p_qualifier)
AND p_date BETWEEN paf.effective_start_date AND paf.effective_end_date
AND p_date BETWEEN pgr.effective_start_date AND pgr.effective_end_date
ORDER BY pgr.effective_start_date DESC;
SELECT TO_NUMBER(ffg.global_value)
FROM ff_globals_f ffg
,per_business_groups_perf pbg
WHERE UPPER(ffg.GLOBAL_NAME) = UPPER(p_qualifier)
AND pbg.business_group_id = l_business_group_id
AND (
(ffg.business_group_id = l_business_group_id
)
OR
( ffg.business_group_id IS NULL
AND
ffg.legislation_code = pbg.legislation_code
)
OR
(
ffg.business_group_id IS NULL
AND
ffg.legislation_code IS NULL
)
)
AND p_date
BETWEEN ffg.effective_start_date
AND ffg.effective_end_date;
SELECT lookup_code
FROM hr_lookups hrl
WHERE hrl.lookup_type = 'PQP_RATE_TYPE'
AND UPPER(hrl.meaning) = p_rate_type_name;
SELECT eei.element_type_extra_info_id
FROM pay_element_type_extra_info eei
WHERE eei.element_type_id = p_element_type_id
AND eei.information_type = 'PQP_UK_ELEMENT_ATTRIBUTION';
SELECT ele.element_type_id
FROM pay_element_type_extra_info eei
,pay_element_types_f ele
WHERE eei.information_type = 'PQP_UK_RATE_TYPE'
AND ele.element_type_id = eei.element_type_id
AND p_calculation_date
BETWEEN ele.effective_start_date
AND ele.effective_end_date
AND eei.eei_information1 = l_rate_code
AND (
( ele.business_group_id IS NOT NULL
AND
ele.business_group_id = l_business_group_id
)
OR
( ele.legislation_code = l_legislation_code
AND
ele.business_group_id IS NULL
)
OR
( ele.legislation_code IS NULL
AND
ele.business_group_id IS NULL
)
);
SELECT ele.element_type_id
FROM pay_element_types_f ele
WHERE UPPER(ele.element_name) = l_rate_name
AND (
( ele.business_group_id = l_business_group_id
)
OR
( ele.legislation_code = l_legislation_code
AND
ele.business_group_id IS NULL
)
OR
( ele.legislation_code IS NULL
AND
ele.business_group_id IS NULL
)
)
AND p_calculation_date BETWEEN ele.effective_start_date
AND ele.effective_end_date;