DBA Data[Home] [Help]

APPS.PER_REFRESH_POSITION SQL Statements

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

Line: 90

  select object_version_number
  from   per_all_positions
  where  position_id = p_position_id;
Line: 158

l_program_update_date	 date;
Line: 169

   select rowid
          ,	position_id
          ,	effective_start_date
          ,	effective_end_date
          ,	availability_status_id
          ,	business_group_id
          ,	entry_step_id
          ,	job_id
          ,	location_id
          ,	organization_id
          ,	pay_freq_payroll_id
          ,	position_definition_id
          ,	position_transaction_id
          ,	prior_position_id
          ,	relief_position_id
          ,	successor_position_id
          ,	supervisor_position_id
          ,	amendment_date
          ,	amendment_recommendation
          ,	amendment_ref_number
          ,	bargaining_unit_cd
          ,	comments
          ,	current_job_prop_end_date
          ,	current_org_prop_end_date
          ,	avail_status_prop_end_date
          ,	date_effective
          ,	hr_general.get_position_date_end(position_id) date_end
          ,	earliest_hire_date
          ,	fill_by_date
          ,	frequency
          ,	fte
          ,	max_persons
          ,	hr_general.decode_position_latest_name(position_id) name
          ,	overlap_period
          ,	overlap_unit_cd
          ,	pay_term_end_day_cd
          ,	pay_term_end_month_cd
          ,	permanent_temporary_flag
          ,	permit_recruitment_flag
          ,	position_type
          ,	posting_description
          ,	probation_period
          ,	probation_period_unit_cd
          ,	replacement_required_flag
          ,	review_flag
          ,	seasonal_flag
          ,	security_requirements
          ,	status
          ,	term_start_day_cd
          ,	term_start_month_cd
          ,	time_normal_finish
          ,	time_normal_start
          ,	update_source_cd
          ,	working_hours
          ,	works_council_approval_flag
          ,	work_period_type_cd
          ,	work_term_end_day_cd
          ,	work_term_end_month_cd
          ,	information1
          ,	information2
          ,	information3
          ,	information4
          ,	information5
          ,	information6
          ,	information7
          ,	information8
          ,	information9
          ,	information10
          ,	information11
          ,	information12
          ,	information13
          ,	information14
          ,	information15
          ,	information16
          ,	information17
          ,	information18
          ,	information19
          ,	information20
          ,	information21
          ,	information22
          ,	information23
          ,	information24
          ,	information25
          ,	information26
          ,	information27
          ,	information28
          ,	information29
          ,	information30
          ,	information_category
          ,	attribute1
          ,	attribute2
          ,	attribute3
          ,	attribute4
          ,	attribute5
          ,	attribute6
          ,	attribute7
          ,	attribute8
          ,	attribute9
          ,	attribute10
          ,	attribute11
          ,	attribute12
          ,	attribute13
          ,	attribute14
          ,	attribute15
          ,	attribute16
          ,	attribute17
          ,	attribute18
          ,	attribute19
          ,	attribute20
          ,	attribute21
          ,	attribute22
          ,	attribute23
          ,	attribute24
          ,	attribute25
          ,	attribute26
          ,	attribute27
          ,	attribute28
          ,	attribute29
          ,	attribute30
          ,	attribute_category
          ,	request_id
          ,	program_application_id
          ,	program_id
          ,	program_update_date
          ,	created_by
          ,	creation_date
          ,	last_updated_by
          ,	last_update_date
          ,	last_update_login
          ,	object_version_number
          ,	entry_grade_id
          ,	entry_grade_rule_id
          ,	proposed_fte_for_layoff
          ,	proposed_date_for_layoff
          ,	pay_basis_id
          ,	supervisor_id
		  , copied_to_old_table_flag
   from   hr_all_positions_f
   where  (copied_to_old_table_flag <> 'Y'
   or     copied_to_old_table_flag is null )
   --and    effective_start_date <= p_refresh_date
   and    position_id = p_position_id
   order by position_id, effective_start_date desc;
Line: 316

   select rowid
          ,	position_id
          ,	effective_start_date
          ,	effective_end_date
          ,	availability_status_id
          ,	business_group_id
          ,	entry_step_id
          ,	job_id
          ,	location_id
          ,	organization_id
          ,	pay_freq_payroll_id
          ,	position_definition_id
          ,	position_transaction_id
          ,	prior_position_id
          ,	relief_position_id
          ,	successor_position_id
          ,	supervisor_position_id
          ,	amendment_date
          ,	amendment_recommendation
          ,	amendment_ref_number
          ,	bargaining_unit_cd
          ,	comments
          ,	current_job_prop_end_date
          ,	current_org_prop_end_date
          ,	avail_status_prop_end_date
          ,	date_effective
          ,	hr_general.get_position_date_end(position_id) date_end
          ,	earliest_hire_date
          ,	fill_by_date
          ,	frequency
          ,	fte
          ,	max_persons
          ,	hr_general.decode_position_latest_name(position_id) name
          ,	overlap_period
          ,	overlap_unit_cd
          ,	pay_term_end_day_cd
          ,	pay_term_end_month_cd
          ,	permanent_temporary_flag
          ,	permit_recruitment_flag
          ,	position_type
          ,	posting_description
          ,	probation_period
          ,	probation_period_unit_cd
          ,	replacement_required_flag
          ,	review_flag
          ,	seasonal_flag
          ,	security_requirements
          ,	status
          ,	term_start_day_cd
          ,	term_start_month_cd
          ,	time_normal_finish
          ,	time_normal_start
          ,	update_source_cd
          ,	working_hours
          ,	works_council_approval_flag
          ,	work_period_type_cd
          ,	work_term_end_day_cd
          ,	work_term_end_month_cd
          ,	information1
          ,	information2
          ,	information3
          ,	information4
          ,	information5
          ,	information6
          ,	information7
          ,	information8
          ,	information9
          ,	information10
          ,	information11
          ,	information12
          ,	information13
          ,	information14
          ,	information15
          ,	information16
          ,	information17
          ,	information18
          ,	information19
          ,	information20
          ,	information21
          ,	information22
          ,	information23
          ,	information24
          ,	information25
          ,	information26
          ,	information27
          ,	information28
          ,	information29
          ,	information30
          ,	information_category
          ,	attribute1
          ,	attribute2
          ,	attribute3
          ,	attribute4
          ,	attribute5
          ,	attribute6
          ,	attribute7
          ,	attribute8
          ,	attribute9
          ,	attribute10
          ,	attribute11
          ,	attribute12
          ,	attribute13
          ,	attribute14
          ,	attribute15
          ,	attribute16
          ,	attribute17
          ,	attribute18
          ,	attribute19
          ,	attribute20
          ,	attribute21
          ,	attribute22
          ,	attribute23
          ,	attribute24
          ,	attribute25
          ,	attribute26
          ,	attribute27
          ,	attribute28
          ,	attribute29
          ,	attribute30
          ,	attribute_category
          ,	request_id
          ,	program_application_id
          ,	program_id
          ,	program_update_date
          ,	created_by
          ,	creation_date
          ,	last_updated_by
          ,	last_update_date
          ,	last_update_login
          ,	object_version_number
          ,	entry_grade_id
          ,	entry_grade_rule_id
          ,	proposed_fte_for_layoff
          ,	proposed_date_for_layoff
          ,	pay_basis_id
          ,	supervisor_id
		  , copied_to_old_table_flag
   from   hr_all_positions_f
   where  (copied_to_old_table_flag <> 'Y'
   or     copied_to_old_table_flag is null )
   --and    effective_start_date <= p_refresh_date
   order by position_id, effective_start_date desc;
Line: 604

              hr_utility.set_location(l_proc||' insert per_all_positions api call ', 50);
Line: 737

   select object_version_number
   from per_all_positions p
   where position_id = p_position_id
   and position_id not in ( select position_id from hr_all_positions_f where position_id = p_position_id) ;
Line: 793

    update per_all_positions
    set date_end = hr_general.get_position_date_end(position_id)
    where position_id = p_position_id;