[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
select effective_date
from fnd_sessions
where session_id = userenv('sessionid');
select legislation_code
from per_business_groups
where business_group_id = p_bus_group_id;
select range_or_match, user_table_id
from pay_user_tables
where upper(user_table_name) = upper(p_table_name)
and nvl (business_group_id,
p_bus_group_id) = p_bus_group_id
and nvl(legislation_code, l_leg_code) = l_leg_code;
select decode(upper(p_low_high_range),'H',R.row_high_range,R.row_low_range_or_name)
from pay_user_column_instances_f CINST
, pay_user_columns C
, pay_user_rows_f R
, pay_user_tables TAB
where TAB.user_table_id = l_table_id
and C.user_table_id = TAB.user_table_id
and nvl (C.business_group_id,
p_bus_group_id) = p_bus_group_id
and nvl (C.legislation_code,
l_leg_code) = l_leg_code
and upper (C.user_column_name) = upper (p_col_name)
and CINST.user_column_id = C.user_column_id
and R.user_table_id = TAB.user_table_id
and l_effective_date between R.effective_start_date
and R.effective_end_date
and nvl (R.business_group_id,
p_bus_group_id) = p_bus_group_id
and nvl (R.legislation_code,
l_leg_code) = l_leg_code
and fnd_number.canonical_to_number (CINST.value) =
fnd_number.canonical_to_number (p_table_value)
and TAB.user_key_units = 'N'
and CINST.user_row_id = R.user_row_id
and l_effective_date between CINST.effective_start_date
and CINST.effective_end_date
and nvl (CINST.business_group_id,
p_bus_group_id) = p_bus_group_id
and nvl (CINST.legislation_code,
l_leg_code) = l_leg_code;
SELECT legislation_code
FROM per_business_groups
WHERE business_group_id = v_bg_id;
c_update_action_if_exists CONSTANT VARCHAR2 (1) := 'U'; --Update existing element entry
c_default_dt_effective_changes CONSTANT VARCHAR2 (1) := 'U'; --Update/Change Insert
IF (p_action_if_exists = c_update_action_if_exists)
THEN
IF (p_date_effective_changes IS NULL)
THEN -- Default p_date_effective_changes
l_date_effective_changes := c_default_dt_effective_changes;
SELECT paa.assignment_number,
pos.date_start,
pos.final_process_date
FROM per_assignments_f paa,
per_periods_of_service pos
WHERE paa.assignment_id = v_assg_id
AND paa.period_of_service_id = pos.period_of_service_id
AND v_effective_date BETWEEN paa.effective_start_date
AND paa.effective_end_date;
SELECT paa.assignment_number,
paa.assignment_id,
pos.date_start,
pos.final_process_date
FROM per_assignments_f paa,
per_periods_of_service pos
WHERE paa.person_id = v_person_id
AND paa.period_of_service_id = pos.period_of_service_id
AND v_effective_date BETWEEN paa.effective_start_date
AND paa.effective_end_date
AND paa.business_group_id = v_bg_id
AND paa.primary_flag = 'Y';
SELECT paa.assignment_number,
paa.assignment_id,
pos.date_start,
pos.final_process_date
FROM per_assignments_f paa,
per_people_f pap,
per_periods_of_service pos
WHERE pap.employee_number = v_empl_nr
AND pap.person_id = paa.person_id
AND paa.period_of_service_id = pos.period_of_service_id
AND v_effective_date BETWEEN paa.effective_start_date
AND paa.effective_end_date
AND v_effective_date BETWEEN pap.effective_start_date
AND pap.effective_end_date
AND paa.business_group_id = v_bg_id
AND paa.primary_flag = 'Y';
SELECT paa.assignment_number,
paa.assignment_id,
pos.date_start,
pos.final_process_date
FROM per_assignments_f paa,
per_people_f pap,
per_periods_of_service pos
WHERE pap.national_identifier = v_ni_nr
AND pap.person_id = paa.person_id
AND paa.period_of_service_id = pos.period_of_service_id
AND v_effective_date BETWEEN paa.effective_start_date
AND paa.effective_end_date
AND v_effective_date BETWEEN pap.effective_start_date
AND pap.effective_end_date
AND paa.business_group_id = v_bg_id
AND paa.primary_flag = 'Y';
SELECT pet.element_name,
pet.element_type_id
FROM pay_element_types_f pet
WHERE pet.element_type_id = v_el_type_id
AND UPPER (pet.element_name) = UPPER (v_el_name)
AND pet.legislation_code = v_leg_cd
AND pet.business_group_id IS NULL;
SELECT pet.element_name,
pet.element_type_id
FROM pay_element_types_f pet
WHERE pet.element_type_id = v_el_type_id
AND pet.legislation_code = v_leg_cd
AND pet.business_group_id IS NULL;
SELECT pet.element_name,
pet.element_type_id
FROM pay_element_types_f pet
WHERE UPPER(pet.element_name) = UPPER(v_el_name)
AND pet.legislation_code = v_leg_cd
AND pet.business_group_id IS NULL;