APPS.HXC_APPROVAL_WF_HELPER dependencies on PER_ALL_ASSIGNMENTS_F

Line 273: l_supervisor_id per_all_assignments_f.supervisor_id%type;

269: ,p_timecard_ovn IN hxc_time_building_blocks.object_version_number%TYPE )
270: return wf_local_roles.name%type
271: is
272:
273: l_supervisor_id per_all_assignments_f.supervisor_id%type;
274: l_name wf_local_roles.name%type;
275: l_display_name wf_local_roles.display_name%type;
276: l_proc constant varchar2(61) := g_pkg ||'find_supervisor_role';
277:

Line 282: from per_all_assignments_f

278: CURSOR c_get_supervisor(p_timecard_id IN hxc_time_building_blocks.time_building_block_id%TYPE
279: ,p_timecard_ovn IN hxc_time_building_blocks.object_version_number%TYPE )
280: is
281: select supervisor_id
282: from per_all_assignments_f
283: where person_id = (select resource_id
284: from hxc_time_building_blocks
285: where time_building_block_id=p_timecard_id
286: and object_version_number =p_timecard_ovn)

Line 295: --This FUNCTION uses the HXC_TIME_BUILDING_BLOCKS table and PER_ALL_ASSIGNMENTS_F to find the supervisor

291: BEGIN
292: if g_debug then
293: hr_utility.set_location(l_proc, 10);
294: end if;
295: --This FUNCTION uses the HXC_TIME_BUILDING_BLOCKS table and PER_ALL_ASSIGNMENTS_F to find the supervisor
296: --corresponding to the primary employee or contingent worker assignment, and then subsequently use that
297: --supervisor id to find the appropriate role from the workflow directory service using the PER original system.
298:
299: open c_get_supervisor(p_timecard_id,p_timecard_ovn);

Line 428: l_supervisor_id per_all_assignments_f.supervisor_id%type;

424: FUNCTION is_approver_supervisor
425: (p_approver_resource_id in number,
426: p_resource_id in number)
427: Return Boolean is
428: l_supervisor_id per_all_assignments_f.supervisor_id%type;
429: l_proc constant varchar2(61) := g_pkg ||'is_approver_supervisor';
430:
431: Cursor get_supervisor(p_resource_id number)
432: Is

Line 434: from per_all_assignments_f

430:
431: Cursor get_supervisor(p_resource_id number)
432: Is
433: select supervisor_id
434: from per_all_assignments_f
435: where person_id = p_resource_id
436: and assignment_type in ('E','C')
437: and primary_flag = 'Y'
438: and sysdate between effective_start_date and effective_END_Date;