APPS.HR_RU_ASG_HOOK SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 6

                               ,p_datetrack_update_mode 	IN  VARCHAR2
                               ,p_assignment_status_type_id     IN   NUMBER
                               ,p_segment1          		IN  VARCHAR2
                               ,p_segment2          		IN  VARCHAR2
                               ,p_segment3          		IN  VARCHAR2
                               ,p_segment4          		IN  VARCHAR2
                               ,p_segment5          		IN  VARCHAR2
                               ,p_segment6          		IN  VARCHAR2
                               ,p_segment7          		IN  VARCHAR2
                               ,p_segment8          		IN  VARCHAR2
                               ,p_segment9          		IN  VARCHAR2
                               ,p_segment10         		IN  VARCHAR2
                               ,p_segment11         		IN  VARCHAR2
                               ,p_segment12         		IN  VARCHAR2
                               ,p_segment13         		IN  VARCHAR2
                               ,p_segment14         		IN  VARCHAR2
                               ,p_segment15         		IN  VARCHAR2
                               ) AS
 CURSOR c_min_start_date(p_assignment_id NUMBER) IS
   SELECT min(effective_start_date)
   FROM  per_all_assignments_f
   WHERE assignment_id = p_assignment_id;

Line: 30

   SELECT person_id,effective_start_date,effective_end_date,business_group_id
   FROM per_all_assignments_f
   WHERE assignment_id = p_assignment_id
   AND p_effective_date between effective_start_date and effective_end_date;

Line: 55

   IF p_datetrack_update_mode = 'UPDATE' THEN
     l_eff_start_date := p_effective_date;

Line: 57

   ELSIF p_datetrack_update_mode = 'UPDATE_CHANGE_INSERT' THEN
     l_eff_start_date := p_effective_date;

Line: 59

   ELSIF p_datetrack_update_mode = 'UPDATE_OVERRIDE' THEN
     l_eff_start_date := p_effective_date;

Line: 68

   	select distinct hou.organization_id
   	INTO l_org_id
   	from HR_ALL_ORGANIZATION_UNITS hou, HR_ALL_ORGANIZATION_UNITS_TL hout, HR_ORGANIZATION_INFORMATION hoi
   	where hou.organization_id   = hoi.organization_id
	AND   hou.organization_id      = hout.organization_id
	AND   hou.organization_id  = to_number(p_segment1)
	AND   hoi.org_information_context  = 'CLASS'
	AND   hoi.org_information1      = 'HR_LEGAL_EMPLOYER'
	AND   hoi.org_information2 = 'Y'
	AND   hout.language  = userenv('LANG')
	AND   p_effective_date  >= hou.date_from
	AND   p_effective_date  <=  NVL(hou.date_to,TO_DATE('31-12-4712','DD-MM-YYYY'));

Line: 151

   	SELECT '1' INTO l_lookup_exists FROM hr_lookups WHERE lookup_type='RU_SPECIAL_WORK_CONDITIONS'
	AND lookup_code=p_segment8 AND enabled_flag='Y';

Line: 162

   	SELECT '1' INTO l_lookup_exists FROM hr_lookups WHERE lookup_type='RU_LONG_SERVICE'
	AND lookup_code=p_segment12 AND enabled_flag='Y';

Line: 218

   SELECT business_group_id
   FROM per_all_people_f
   WHERE person_id = p_person_id
   AND p_effective_date between effective_start_date and effective_end_date;

Line: 243

   	select distinct hou.organization_id
   	INTO l_org_id
   	from HR_ALL_ORGANIZATION_UNITS hou, HR_ALL_ORGANIZATION_UNITS_TL hout, HR_ORGANIZATION_INFORMATION hoi
   	where hou.organization_id   = hoi.organization_id
	AND   hou.organization_id      = hout.organization_id
	AND   hou.organization_id  = to_number(p_scl_segment1)
	AND   hoi.org_information_context  = 'CLASS'
	AND   hoi.org_information1      = 'HR_LEGAL_EMPLOYER'
	AND   hoi.org_information2 = 'Y'
	AND   hout.language  = userenv('LANG')
	AND   p_effective_date  >= hou.date_from
	AND   p_effective_date  <=  NVL(hou.date_to,TO_DATE('31-12-4712','DD-MM-YYYY'));

Line: 322

   	SELECT '1' INTO l_lookup_exists FROM hr_lookups WHERE lookup_type='RU_SPECIAL_WORK_CONDITIONS'
	AND lookup_code=p_scl_segment8 AND enabled_flag='Y';

Line: 333

   	SELECT '1' INTO l_lookup_exists FROM hr_lookups WHERE lookup_type='RU_LONG_SERVICE'
	AND lookup_code=p_scl_segment12 AND enabled_flag='Y';