[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT SUBSTR(LTRIM(RTRIM(
DECODE(p_last_name, NULL, '', ' ' || p_last_name)
||DECODE(p_per_information1, NULL,'',' ' || p_per_information1)
||DECODE(p_first_name,NULL, '', ' ' || p_first_name)
||DECODE(p_middle_names,NULL, '', ' ' || p_middle_names)
)), 1, 240)
INTO l_full_name
FROM dual;
select distinct(pghn_gre.entity_id)
from per_gen_hierarchy pgh,
per_gen_hierarchy_versions pghv,
per_gen_hierarchy_nodes pghn_loc,
per_gen_hierarchy_nodes pghn_gre
where pgh.type = 'MEXICO HRMS'
and pghv.hierarchy_id = pgh.hierarchy_id
and p_session_date BETWEEN pghv.date_from
AND nvl(pghv.date_to, hr_general.end_of_time)
and pghv.status = 'A'
and pghn_loc.hierarchy_version_id = pghv.hierarchy_version_id
and pghn_loc.node_type = 'MX LOCATION'
and pghn_loc.entity_id = p_location_id
and pghn_gre.hierarchy_node_id = pghn_loc.parent_hierarchy_node_id
and pghn_gre.hierarchy_version_id = pghv.hierarchy_version_id
and pghn_gre.business_group_id = p_business_group_id -- Bug 4129001
and pghn_gre.node_type = 'MX GRE';
SELECT segment1
FROM hr_soft_coding_keyflex
WHERE soft_coding_keyflex_id = p_soft_coding_keyflex_id;
SELECT legislation_code
FROM per_business_groups pbg
WHERE pbg.business_group_id = p_business_group_id;
SELECT business_group_id
FROM per_people_f
WHERE person_id = p_person_id
AND rownum < 2;
SELECT business_group_id
FROM per_assignments_f
WHERE assignment_id = p_assignment_id
AND rownum < 2;
SELECT effective_date
INTO ld_effective_date
FROM fnd_sessions
WHERE session_id = USERENV('sessionid');
SELECT le_node.entity_id
INTO r_legal_employer_id
FROM per_gen_hierarchy_nodes gre_node,
per_gen_hierarchy_nodes le_node,
per_gen_hierarchy_versions hier_ver,
fnd_lookup_values lv
WHERE gre_node.node_type = 'MX GRE'
AND gre_node.entity_id = p_tax_unit_id
AND gre_node.business_group_id = p_business_group_id
AND gre_node.hierarchy_version_id = le_node.hierarchy_version_id
AND le_node.hierarchy_node_id = gre_node.parent_hierarchy_node_id
AND gre_node.hierarchy_version_id = hier_ver.hierarchy_version_id
AND status = lv.lookup_code
AND lv.meaning = 'Active'
AND lv.LANGUAGE = 'US'
AND lv.lookup_type = 'PQH_GHR_HIER_VRSN_STATUS'
AND p_effective_date BETWEEN hier_ver.date_from
AND NVL(hier_ver.date_to, hr_general.end_of_time);
SELECT name
INTO lv_org_name
FROM hr_all_organization_units
WHERE organization_id = p_organization_id;
SELECT pps.adjusted_svc_date
FROM per_periods_of_service pps,
per_all_people_f pap
WHERE pap.person_id = p_person_id
AND pps.person_id = pap.person_id
AND p_effective_date BETWEEN pap.effective_start_date
AND pap.effective_end_date
AND pps.date_start = (SELECT MAX (pps1.date_start)
FROM per_periods_of_service pps1
WHERE pps1.person_id = pps.person_id
AND pps1.date_start <= p_effective_date);
SELECT NVL(original_date_of_hire, start_date)
FROM per_all_people_f
WHERE person_id = p_person_id
ORDER BY 1 desc;
SELECT CEIL((p_effective_date - get_hire_anniversary (
p_person_id,
p_effective_date))/365)
INTO ln_seniority_years
FROM DUAL ;
SELECT ROUND( (p_effective_date - ld_hire_date) / ln_days_in_a_year )
INTO ln_seniority_years
FROM DUAL ;
SELECT tag
FROM fnd_lookup_values
WHERE lookup_type = 'FND_ISO_CHARACTER_SET_MAP'
AND lookup_code = SUBSTR(USERENV('LANGUAGE'),
INSTR(USERENV('LANGUAGE'), '.') + 1)
AND language = 'US';
SELECT 'Y'
FROM hr_lookups hll
WHERE hll.lookup_type = p_lookup_type
AND hll.lookup_code = p_entry_val
AND hll.enabled_flag = 'Y'
AND p_effective_date BETWEEN NVL(hll.start_date_active, p_effective_date)
AND NVL(hll.end_date_active, p_effective_date);