APPS.FA_PERSON dependencies on DUAL

Line 18: from dual

14: --
15: begin
16: select 'Y'
17: into v_delete_permitted
18: from dual
19: where not exists (
20: select 'X'
21: from fa_massadd_distributions md
22: where md.employee_id = P_PERSON_ID);

Line 34: from dual

30: --
31: begin
32: select 'Y'
33: into v_delete_permitted
34: from dual
35: where not exists (
36: select 'X'
37: from fa_distribution_history dh
38: where dh.assigned_to = P_PERSON_ID);

Line 50: from dual

46: --
47: begin
48: select 'Y'
49: into v_delete_permitted
50: from dual
51: where not exists (
52: select 'X'
53: from fa_mass_transfers mt
54: where mt.from_employee_id = P_PERSON_ID