APPS.PER_JP_VALIDATIONS SQL Statements

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

Line: 191

				select	'X'
				from	per_jp_address_lookups
				where	district_code = p_district_code;

Line: 262

			select	'X'
			from	hr_organization_information	hoi,
				hr_all_organization_units	hou
			where	hou.business_group_id=p_business_group_id
			and	hou.organization_id=p_organization_id
			-- and	to_date(p_effective_date,'DD-MON-YYYY')
			--between hou.date_from and nvl(hou.date_to,to_date(p_effective_date,'DD-MON-YYYY'))
			and	p_effective_date
				between hou.date_from and nvl(hou.date_to,p_effective_date)
			and	hoi.organization_id=hou.organization_id
			and	hoi.org_information_context='CLASS'
			and	hoi.org_information1=p_org_class
			and	hoi.org_information2='Y';

Line: 319

			select	'X'
			from	pqp_vehicle_allocations_f pva,
				pqp_vehicle_repository_f  pvr
			where	pva.business_group_id=p_business_group_id
			and	pva.assignment_id=p_assignment_id
			and	pva.vehicle_allocation_id=p_vehicle_allocation_id
			and	p_effective_date
				between pva.effective_start_date and nvl(pva.effective_end_date,p_effective_date)
			and	pvr.vehicle_repository_id = pva.vehicle_repository_id
			and	p_effective_date
				between pvr.effective_start_date and nvl(pvr.effective_end_date,p_effective_date);