DBA Data[Home] [Help]

APPS.PQH_AME_UTILS dependencies on PER_ALL_ASSIGNMENTS_F

Line 142: from per_all_assignments_f

138: -- ---------------------------------------------------------------------------
139: function get_requestor_person_id( p_transaction_id in varchar2) return varchar2 is
140: cursor csr_mgr (c_person_id in number) is
141: select supervisor_id
142: from per_all_assignments_f
143: where person_id = c_person_id
144: and sysdate between effective_start_date and effective_end_date;
145: --
146: l_supervisor_id number(18);