APPS.FA_PERSON SQL Statements

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

Line: 8

  v_delete_permitted	varchar2(1);

Line: 15

	select 'Y'
	into	v_delete_permitted
	from	dual
	where	not exists (
		select	'X'
		from	fa_massadd_distributions md
		where	md.employee_id = P_PERSON_ID);

Line: 31

	select 'Y'
	into	v_delete_permitted
	from	dual
	where	not exists (
		select	'X'
		from	fa_distribution_history	dh
		where	dh.assigned_to = P_PERSON_ID);

Line: 47

	select 'Y'
	into	v_delete_permitted
	from	dual
	where	not exists (
		select	'X'
		from	fa_mass_transfers	mt
		where	mt.from_employee_id = P_PERSON_ID
		or	mt.to_employee_id = P_PERSON_ID);