APPS.HR_JP_ID_PKG SQL Statements

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

Line: 38

		g_sql	:= 'select * from ' || p_base_table;

Line: 375

			select	currency_code
			from	fnd_currencies
			where	issuing_territory_code = p_legislation_code;

Line: 1662

			select	pdb.*
			from	pay_balance_dimensions	pbd,
				pay_defined_balances	pdb,
				pay_balance_types	pbt
			where	pbt.assignment_remuneration_flag='Y'
			and	nvl(pbt.business_group_id,p_business_group_id)=p_business_group_id
			and	nvl(pbt.legislation_code,l_legislation_code)=l_legislation_code
			and	pdb.balance_type_id=pbt.balance_type_id
			and	nvl(pdb.business_group_id,p_business_group_id)=p_business_group_id
			and	nvl(pdb.legislation_code,l_legislation_code)=l_legislation_code
			and	pbd.balance_dimension_id=pdb.balance_dimension_id
			and	nvl(pbd.business_group_id,p_business_group_id)=p_business_group_id
			and	nvl(pbd.legislation_code,l_legislation_code)=l_legislation_code
			and	pbd.payments_flag='Y';

Line: 1869

			select	pps.*
			from	per_periods_of_service	pps,
				per_all_people_f	pp
			where	pp.employee_number=p_employee_number
			and	pp.business_group_id=p_business_group_id
			and	p_effective_date
				between pp.effective_start_date and pp.effective_end_date
			and	pps.person_id=pp.person_id
			and	(	pps.date_start=(
						select	max(pps2.date_start)
						from	per_periods_of_service	pps2
						where	pps2.person_id=pp.person_id
						and	pps2.date_start <= pp.effective_end_date)
				);

Line: 1912

			select	pee.*
			from	pay_element_links_f	pel,
				pay_element_entries_f	pee
			where	pee.assignment_id=p_assignment_id
			and	pee.entry_type=p_entry_type
			and	p_effective_date
				between pee.effective_start_date and pee.effective_end_date
			and	pel.element_link_id=pee.element_link_id
			and	pel.element_type_id=p_element_type_id
			and	p_effective_date
				between pel.effective_start_date and pel.effective_end_date
			and	pee.entry_type='E'
			order by pee.element_entry_id;