APPS.HR_GENERAL2 dependencies on ALL_TRIGGERS

Line 105: alogue 31-Mar-2004 115.44 3544109 Changed all_triggers to user_triggers.

101: for JP legislation
102: dcasemor 01-Mar-2004 115.42 3346940 Added supervisor_assignments_in_use.
103: dcasemor 11-Mar-2004 115.43 3346940 Changed supervisor_assignments_in_use
104: so it references a new profile option.
105: alogue 31-Mar-2004 115.44 3544109 Changed all_triggers to user_triggers.
106: kramajey 13-Jun-2005 115.45 4341787 Changed the join in the sql statement
107: in is_duplicate_person procedure
108: for performance in JP Legislation.
109: sgelvi 31-May-2006 115.46 Added hrms_efc_column function

Line 963: l_ovn_trigger all_triggers.trigger_name%TYPE := null;

959: where uv.view_name = atc.table_name
960: and uv.owner = p_owner)
961: order by 1;
962: --
963: l_ovn_trigger all_triggers.trigger_name%TYPE := null;
964: l_proc varchar2(72);
965: --
966: -- Local function establishes for a single database table
967: -- if an OVN trigger exists and the full trigger name.

Line 972: l_ovn_trigger_name all_triggers.trigger_name%TYPE := null;

968: --
969: function get_ovn_trigger
970: (p_table_name in varchar2)
971: return varchar2 is
972: l_ovn_trigger_name all_triggers.trigger_name%TYPE := null;
973: begin
974: select alt.trigger_name
975: into l_ovn_trigger_name
976: from user_triggers alt