APPS.PER_FR_VALIDATE_DELETE_PKG SQL Statements

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

Line: 15

	SELECT '1'
	FROM HR_ORGANIZATION_INFORMATION
	WHERE ORG_INFORMATION_CONTEXT = 'FR_ESTAB_URSSAF'
	AND TO_NUMBER(ORG_INFORMATION1) = x_organization_id;

Line: 21

	SELECT '1'
	FROM HR_ORGANIZATION_INFORMATION
	WHERE ORG_INFORMATION_CONTEXT = 'FR_ESTAB_ASSEDIC'
	AND TO_NUMBER(ORG_INFORMATION1) = x_organization_id;

Line: 27

	SELECT '1'
	FROM HR_ORGANIZATION_INFORMATION
	WHERE ORG_INFORMATION_CONTEXT = 'FR_ESTAB_PE_PRVS'
	AND TO_NUMBER(ORG_INFORMATION1) = x_organization_id;

Line: 33

	SELECT '1'
	FROM HR_ORGANIZATION_INFORMATION
	WHERE ORG_INFORMATION_CONTEXT = 'FR_ESTAB_INS_PRV'
	AND TO_NUMBER(ORG_INFORMATION1) = x_organization_id;

Line: 39

	SELECT '1'
	FROM  HR_ORGANIZATION_INFORMATION
	WHERE ORG_INFORMATION_CONTEXT = 'FR_COMP_INFO'
	AND x_organization_id = to_number(ORG_INFORMATION3);

Line: 45

	select 1
	from hr_organization_information oi, hr_all_organization_units ou
	where oi.organization_id = ou.organization_id
	and oi.organization_id = x_organization_id
	and oi.org_information_context = 'FR_ESTAB_INFO'
	and to_number (oi.org_information1) =
	(select ou.organization_id
 	from hr_all_organization_units ou, hr_organization_information oi
 	where to_number (oi.org_information4) = x_organization_id
 	and oi.organization_id = ou.organization_id
 	and oi.org_information_context = 'FR_COMP_INFO');

Line: 58

	select 1
	from hr_organization_information oi, hr_all_organization_units ou
	where oi.organization_id = ou.organization_id
	and oi.organization_id = x_organization_id
	and oi.org_information_context = 'FR_ESTAB_INFO'
	and to_number (oi.org_information1) =
	(select ou.organization_id
 	from hr_all_organization_units ou, hr_organization_information oi
 	where to_number (oi.org_information5) = x_organization_id
 	and oi.organization_id = ou.organization_id
 	and oi.org_information_context = 'FR_COMP_INFO');

Line: 71

	SELECT '1'
	FROM  HR_ORGANIZATION_INFORMATION
	WHERE ORG_INFORMATION_CONTEXT (+)  = 'FR_COMP_PE_PRVS'
	AND x_organization_id = to_number(ORG_INFORMATION1);

Line: 77

	SELECT '1'
	FROM  HR_ORGANIZATION_INFORMATION
	WHERE ORG_INFORMATION_CONTEXT (+)  = 'FR_COMP_INS_PRVS'
	AND x_organization_id = to_number(ORG_INFORMATION1);

Line: 84

	select '1'
	from per_collective_agreements_v
	where employer_organization_id = x_organization_id;

Line: 89

	select '1'
	from per_collective_agreements_v
	where bargaining_organization_id = x_organization_id;

Line: 94

	select '1'
	from per_all_people_f pap
	where pap.per_information_category = 'FR'
                        and   to_number(pap.per_information11)
                                                         = x_organization_id;

Line: 101

	select '1'
	from per_all_assignments_f paa
	where paa.establishment_id = x_organization_id;

Line: 249

end validate_delete;