APPS.HR_PERSON_FLEX_LOGIC SQL Statements

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

Line: 106

   select  value
   from	   per_assignment_budget_values_f
   where   assignment_id  = p_assignment_id
   and	   unit           = p_ABV
   and	   p_session_date between effective_start_date and effective_end_date;

Line: 319

   select 'Y'
   from   per_job_extra_info
   where  information_type    = 'Job Category'
   and    JEI_INFORMATION1    = p_job_category
   and    job_id              = p_job_id;

Line: 363

   SELECT formula_id
   FROM   ff_formulas_f
   WHERE  business_group_id+0 = p_business_group_id
   AND    SYSDATE BETWEEN effective_start_date AND effective_end_date
   AND    formula_name        = 'HR_MOVE_TYPE';

Line: 371

   SELECT formula_id
   FROM   ff_formulas_f
   WHERE  business_group_id+0 is null
   AND    SYSDATE BETWEEN effective_start_date AND effective_end_date
   AND    formula_name = 'HR_MOVE_TYPE_TEMPLATE';

Line: 505

select ast.per_system_status status
,      asg.effective_start_date
,      asg.effective_end_date
,      asg.organization_id
from   per_assignment_status_types ast
,      per_all_assignments_f asg
where  asg.assignment_status_type_id = ast.assignment_status_type_id
and    asg.assignment_id = p_assignment_id
and    asg.effective_start_date	<= p_period_end_date
order by asg.effective_start_date desc;

Line: 517

select per.start_date
from   per_all_people_f		per
,      per_all_assignments_f		asg
where  asg.person_id	  = per.person_id
and    p_period_end_date between per.effective_start_date and per.effective_end_date
and    p_period_end_date between asg.effective_start_date and asg.effective_end_date
and    asg.assignment_id  = p_assignment_id;

Line: 526

select pos.actual_termination_date
from   per_periods_of_service		pos
      ,per_all_assignments_f		asg
where  asg.period_of_service_id	= pos.period_of_service_id
and    p_period_start_date-1 between asg.effective_start_date
				 and asg.effective_end_date
and	asg.assignment_id = p_assignment_id;

Line: 535

select pps.actual_termination_date
from   per_periods_of_placement		pps
      ,per_all_assignments_f		asg
where  asg.person_id	= pps.person_id
and    asg.period_of_placement_date_start = pps.date_start
and    p_period_start_date-1 between asg.effective_start_date
				 and asg.effective_end_date
and	asg.assignment_id = p_assignment_id;

Line: 704

select 	'Y'
from 	per_periods_of_service pos
where	pos.date_start between add_months(p_report_date,-1) and p_report_date
and 		pos.period_of_service_id in (
			select    paf.period_of_service_id
			from	  per_all_assignments_f  paf
			where     paf.period_of_service_id = pos.period_of_service_id
			and	  paf.organization_id = p_organization_id
			and	  paf.assignment_id   = p_assignment_id);

Line: 757

select 	'Y'
from 	per_periods_of_service pos
where	pos.date_start between p_cur_date_from and p_cur_date_to
and 		pos.period_of_service_id in (
			select paf.period_of_service_id
			from	  per_all_assignments_f  paf
			where     paf.period_of_service_id = pos.period_of_service_id
			and	  paf.organization_id = p_organization_id
			and	  paf.assignment_id   = p_assignment_id);

Line: 773

select 	'Y'
from 	per_periods_of_placement pps
where	pps.date_start between p_cur_date_from and p_cur_date_to
and     exists (select 1
               from      per_all_assignments_f  paf
               where     paf.person_id = pps.person_id
               and       paf.period_of_placement_date_start = pps.date_start
               and       paf.organization_id   = p_organization_id
               and       paf.assignment_id     = p_assignment_id);

Line: 839

select substr(org_information1,1,60)
from hr_organization_information
where organization_id = P_ORGANIZATION_ID
and org_information_context = 'Organization Name Alias'
and P_REPORT_DATE between
	nvl(fnd_date.canonical_to_date(org_information3),hr_api.g_sot)
	and nvl(fnd_date.canonical_to_date(org_information4),hr_api.g_eot);

Line: 848

select name
from hr_organization_units
where organization_id = P_ORGANIZATION_ID
and P_REPORT_DATE between  date_from and
		nvl(date_to,to_date('31/12/4712','DD/MM/YYYY'));

Line: 892

select formula_name
from   ff_formulas_f
where  formula_id = p_formula_id;

Line: 920

   select formula_type_id
   from   ff_formula_types
   where  upper(formula_type_name) = upper(p_formula_type_name);

Line: 963

   SELECT formula_id
   FROM   ff_formulas_f
   WHERE  business_group_id+0 = p_business_group_id
   AND    SYSDATE BETWEEN effective_start_date AND effective_end_date
   AND    formula_name        = p_formula_name
   AND    formula_type_id
               = HR_PERSON_FLEX_LOGIC.GetFormulaTypeID(p_formula_type);

Line: 973

   SELECT formula_id
   FROM   ff_formulas_f
   WHERE  business_group_id+0 is null
   AND    SYSDATE BETWEEN effective_start_date AND effective_end_date
   AND    formula_name = p_formula_name||'_TEMPLATE'
   AND    formula_type_id
               = HR_PERSON_FLEX_LOGIC.GetFormulaTypeID(p_formula_type);