[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT SUBSTR (fnd_global.conc_request_id,
-1
* (LEAST (p_from_last,
LENGTH (fnd_global.conc_request_id)
)
)
)
INTO l_conc_request_id_suffix
FROM DUAL;
SELECT MAX (pbh.batch_id) batch_id
FROM pay_batch_headers pbh
WHERE pbh.batch_reference = p_batch_ref
AND pbh.business_group_id = p_bg_id
AND ( (pbh.batch_status <> p_invalid_batch_status)
OR (p_invalid_batch_status IS NULL)
);
SELECT batch_name
FROM pay_batch_headers pbh
WHERE pbh.batch_id = p_batch_id;
SELECT MAX (pbh.batch_id) -- we need to do max because name is not unique
FROM pay_batch_headers pbh
WHERE pbh.batch_name = p_batch_name
AND pbh.business_group_id = p_bg_id;
SELECT MAX (pbh.batch_id) -- we need to do max because name is not unique
FROM pay_batch_headers pbh
WHERE pbh.batch_name = p_batch_reference
AND pbh.business_group_id = p_bg_id;
SELECT COUNT (pbl.batch_line_id)
FROM pay_batch_lines pbl
WHERE pbl.batch_id = p_batch_id;
SELECT COUNT (pbl.batch_line_id)
FROM pay_batch_lines pbl, pay_batch_headers pbh
WHERE pbl.batch_id = pbh.batch_id
AND pbh.business_group_id = p_bg_id
AND batch_reference = p_batch_reference;
SELECT hsck.segment1 gre
FROM per_all_assignments_f paaf, hr_soft_coding_keyflex hsck
WHERE paaf.assignment_id = p_assignment_id
AND p_effective_date BETWEEN paaf.effective_start_date
AND paaf.effective_end_date
AND paaf.soft_coding_keyflex_id = hsck.soft_coding_keyflex_id;
SELECT paf.assignment_id, paf.assignment_type,
past.per_system_status, paf.effective_start_date,
paf.effective_end_date
FROM per_assignments_f paf, per_assignment_status_types past
WHERE p_effective_date BETWEEN paf.effective_start_date
AND paf.effective_end_date
AND paf.primary_flag = c_primary_assignment
AND paf.person_id = p_person_id
AND ( INSTR (p_asg_type_list, paf.assignment_type) <> 0
OR LENGTH (p_asg_type_list) IS NULL -- if the list is empty ALL asg are valid
)
AND past.assignment_status_type_id = paf.assignment_status_type_id
AND ( INSTR (p_asg_system_type_list, past.per_system_status) <>
0
OR LENGTH (p_asg_system_type_list) IS NULL -- if the list is empty ALL asg are valid
);
SELECT paaf.assignment_number, paaf.payroll_id, paaf.organization_id,
paaf.location_id, paaf.business_group_id,
paaf.assignment_type, paaf.effective_start_date,
paaf.effective_end_date
FROM per_all_assignments_f paaf
WHERE paaf.assignment_id = p_assignment_id
AND p_effective_date BETWEEN paaf.effective_start_date
AND paaf.effective_end_date;
SELECT petft.element_name
FROM pay_element_types_f petf, pay_element_types_f_tl petft
WHERE petf.element_type_id = p_ele_type_id
AND petft.element_type_id = petf.element_type_id
AND USERENV ('LANG') = petft.LANGUAGE
AND p_effective_date BETWEEN petf.effective_start_date
AND petf.effective_end_date;
SELECT piv.NAME
FROM pay_input_values_f piv
WHERE piv.element_type_id = p_element_type_id
AND p_effective_date BETWEEN piv.effective_start_date
AND piv.effective_end_date
ORDER BY piv.display_sequence, piv.NAME;
SELECT fdfcu.end_user_column_name
FROM fnd_descr_flex_column_usages fdfcu,
hxc_mapping_components mpc
WHERE fdfcu.application_id = g_hxc_app_id
AND fdfcu.descriptive_flexfield_name = g_otl_info_types_ddf
AND fdfcu.descriptive_flex_context_code = p_context
AND fdfcu.application_column_name = mpc.SEGMENT
AND UPPER (mpc.field_name) = UPPER (p_field_name);
SELECT DISTINCT piv.NAME
FROM pay_input_values_f piv,
pay_accrual_plans pap,
pay_net_calculation_rules pncr
WHERE piv.element_type_id = p_element_type_id
AND p_effective_date BETWEEN piv.effective_start_date
AND piv.effective_end_date
AND pncr.date_input_value_id = piv.input_value_id
AND pncr.input_value_id <> pap.pto_input_value_id
AND pncr.input_value_id <> pap.co_input_value_id
AND pncr.accrual_plan_id = pap.accrual_plan_id
AND pap.accrual_plan_id = p_accrual_plan_id;
SELECT pap.accrual_plan_id
FROM pay_accrual_plans pap,
pay_element_links_f pelf,
pay_element_entries_f peef
WHERE pelf.element_type_id = pap.accrual_plan_element_type_id
AND p_effective_date BETWEEN pelf.effective_start_date
AND pelf.effective_end_date
AND peef.element_link_id = pelf.element_link_id
AND peef.assignment_id = p_assignment_id
AND p_effective_date BETWEEN peef.effective_start_date
AND peef.effective_end_date
ORDER BY accrual_plan_id;
SELECT lookup_code, start_date_active, end_date_active
FROM hr_lookups
WHERE meaning = p_meaning
AND lookup_type = g_element_iv_translations
AND application_id = g_per_app_id
AND enabled_flag = g_lookup_enabled
AND p_date_active BETWEEN NVL (start_date_active, p_date_active)
AND NVL (end_date_active, p_date_active);
SELECT assignment_id
FROM per_all_assignments_f
WHERE assignment_number = p_assignment_number
AND business_group_id = p_bg_id
AND p_effective_date BETWEEN effective_start_date
AND effective_end_date;
SELECT assignment_number
FROM per_all_assignments_f
WHERE assignment_id = p_assignment_id
AND p_effective_date BETWEEN effective_start_date
AND effective_end_date;
SELECT ffv.flex_value
FROM fnd_id_flex_segments fifs,
fnd_flex_value_sets ffvs,
fnd_flex_values ffv
WHERE fifs.application_id = g_pay_app_id
AND fifs.id_flex_code = g_cost_flex_code
AND fifs.id_flex_num = p_id_flex_num
AND fifs.application_column_name = p_segment_name
AND fifs.flex_value_set_id = ffvs.flex_value_set_id
AND ffvs.validation_type = p_validation_type
AND ffvs.flex_value_set_id = ffv.flex_value_set_id
AND ffv.flex_value_id = p_flex_value_id;
SELECT concatenated_segments
FROM pay_cost_allocation_keyflex
WHERE cost_allocation_keyflex_id = p_cost_allocation_keyflex_id;
FUNCTION is_deleted (
p_tbb_rec IN hxc_generic_retrieval_pkg.r_building_blocks
)
RETURN BOOLEAN
AS
l_proc proc_name ;
l_is_deleted BOOLEAN := FALSE;
|| 'is_deleted';
IF (UPPER (p_tbb_rec.deleted) = g_tbb_deleted)
THEN
l_is_deleted := TRUE;
|| ' deleted',
20
);
l_is_deleted := FALSE;
RETURN l_is_deleted;
END is_deleted;