DBA Data[Home] [Help]

APPS.FA_PERSON dependencies on DUAL

Line 17: from dual

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

Line 33: from dual

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

Line 49: from dual

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