[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT eltv.hxt_earning_category
INTO o_earning_cat
FROM hxt_pay_element_types_f_ddf_v eltv
WHERE eltv.element_type_id = i_element_type_id;
SELECT person_id,
last_name,
first_name
INTO o_person_id,
o_last_name,
o_first_name
FROM per_people_f
WHERE employee_number = i_employee_number
AND i_date_worked BETWEEN effective_start_date
AND effective_end_date
AND business_group_id = i_business_group_id;
SELECT id
INTO o_earn_pol_id
FROM hxt_earning_policies
WHERE name = i_earn_pol_name
AND i_date_worked BETWEEN effective_start_date
AND effective_end_date;
SELECT ep.id
INTO o_earn_pol_id
FROM hxt_earning_policies ep,
hxt_per_aei_ddf_v pafv
WHERE pafv.assignment_id = i_assignment_id
AND i_date_worked BETWEEN pafv.effective_start_date
AND pafv.effective_end_date
AND pafv.hxt_earning_policy = ep.id
AND i_date_worked BETWEEN ep.effective_start_date
AND ep.effective_end_date;
SELECT MAX('Y') --5574629
INTO l_exists
FROM pay_element_links_f ell,
per_all_assignments_f asm,
hxt_pay_element_types_f_ddf_v eltv
WHERE asm.assignment_id = p_asg_id
AND p_date_worked BETWEEN asm.effective_start_date
AND asm.effective_end_date
AND ell.element_type_id = p_element_type_id
AND p_date_worked BETWEEN ell.effective_start_date
AND ell.effective_end_date
-- Condition modified for Bug 2669059
-- AND eltv.element_type_id = p_element_type_id
AND eltv.element_type_id = ell.element_type_id
AND p_date_worked BETWEEN eltv.effective_start_date
AND eltv.effective_end_date
AND eltv.hxt_earning_category is not null
AND nvl(ell.organization_id,nvl(asm.organization_id,-1)) =
nvl(asm.organization_id,-1)
AND (ell.people_group_id is null
or exists (SELECT 'x'
FROM pay_assignment_link_usages_f usage
WHERE usage.assignment_id = asm.assignment_id
AND usage.element_link_id = ell.element_link_id
AND p_date_worked BETWEEN usage.effective_start_date
AND usage.effective_end_date))
AND nvl(ell.job_id, nvl(asm.job_id,-1)) = nvl(asm.job_id,-1)
AND nvl(ell.position_id, nvl(asm.position_id,-1)) = nvl(asm.position_id,-1)
AND nvl(ell.grade_id,nvl(asm.grade_id,-1)) = nvl(asm.grade_id,-1)
AND nvl(ell.location_id,nvl(asm.location_id,-1)) = nvl(asm.location_id,-1)
AND nvl(ell.payroll_id,nvl(asm.payroll_id,-1)) = nvl(asm.payroll_id,-1)
AND nvl(ell.employment_category, nvl(asm.employment_category,-1)) =
nvl(asm.employment_category,-1)
AND nvl(ell.pay_basis_id,nvl(asm.pay_basis_id,-1)) =
nvl(asm.pay_basis_id,-1)
AND nvl(ell.business_group_id, nvl(asm.business_group_id,-1)) =
nvl(asm.business_group_id,-1);
SELECT elt.element_type_id
INTO o_element_type_id
FROM pay_element_types_f elt,
pay_element_types_f_tl eltt
WHERE eltt.element_name = i_element_name
AND eltt.language = userenv('LANG')
AND elt.element_type_id = eltt.element_type_id
AND (elt.business_group_id = i_bg_id or elt.business_group_id is null)
AND ( legislation_code = ( SELECT legislation_code
FROM per_business_groups
WHERE business_group_id = i_bg_id) or
legislation_code is NULL )
AND i_date_worked BETWEEN elt.effective_start_date
AND elt.effective_end_date ;
SELECT grade_id
INTO o_grade_id
FROM per_grades
WHERE name = i_grade_name
AND business_group_id + 0 = i_business_group_id
AND i_date_worked BETWEEN date_from
AND nvl(date_to,hr_general.end_of_time);
SELECT location_id
INTO o_location_id
FROM hr_locations
WHERE location_code = i_location_code
AND COUNTRY = 'US'
AND i_date_worked <= NVL(INACTIVE_DATE, i_date_worked);
/* PWM 05-APR-00 Added organization id to select clause */
SELECT PRJ.PROJECT_ID
INTO o_project_id
FROM HXT_ALL_PROJECTS_V PRJ
WHERE PRJ.PROJECT_NUMBER = i_project_number;
/* PWM 05-APR-00 Added organization id to select clause
*/
RETURN 0;
SELECT TAS.TASK_ID
INTO o_task_id
FROM HXT_ALL_TASKS_V TAS
WHERE TAS.task_number = i_task_number
AND TAS.project_id = i_project_id ;
SELECT fcl.meaning
INTO hold_reason_code
FROM hr_lookups fcl
WHERE fcl.lookup_code = i_earn_reason_code
AND i_date_worked BETWEEN NVL(fcl.start_date_active, i_date_worked)
AND NVL(fcl.end_date_active, i_date_worked)
AND fcl.application_id = g_orcl_hr_app_id_cons
AND fcl.enabled_flag = 'Y'
AND fcl.lookup_type = 'ELE_ENTRY_REASON';
SELECT '1'
INTO l_dummy
FROM hxt_sum_hours_worked
WHERE id = i_time_summary_id;
selects the foreign key column(s) into the hidden base table item(s)
********************************************************************/
FUNCTION validate_cost_center_id(i_cost_center_id IN NUMBER,
i_date_worked IN DATE )RETURN NUMBER
IS
hold_cost_center_id NUMBER(15);
SELECT PCAK.COST_ALLOCATION_KEYFLEX_ID
INTO hold_cost_center_id
FROM PAY_COST_ALLOCATION_KEYFLEX PCAK
WHERE PCAK.COST_ALLOCATION_KEYFLEX_ID = i_cost_center_id;
SELECT fcl.lookup_code
INTO o_timecard_source_code
FROM hr_lookups fcl
/* WHERE fcl.meaning = i_timecard_source bug 2398037 */
WHERE fcl.lookup_code = 'S'
AND i_date_worked BETWEEN NVL(fcl.start_date_active, i_date_worked)
AND NVL(fcl.end_date_active, i_date_worked)
AND fcl.application_id = g_orcl_tm_app_id_cons
AND fcl.enabled_flag = 'Y'
AND fcl.lookup_type = 'HXT_TIMECARD_SOURCE';
SELECT prev_wage_code
INTO hold_wage_code
FROM hxt_prev_wage_base pwb
WHERE pwb.prev_wage_code = i_wage_code
AND i_date_worked BETWEEN pwb.effective_start_date
AND pwb.effective_end_date;
SELECT effective_date
INTO hold_sess_date
FROM fnd_sessions
WHERE session_id = USERENV('SESSIONID');