DBA Data[Home] [Help]

APPS.HXC_SUPERVISOR_DASHBOARD dependencies on PER_ALL_PEOPLE_F

Line 921: per_all_people_f per

917: per.full_name,
918: htt.resource_id
919: FROM
920: hxc_temp_tcd htt,
921: per_all_people_f per
922: WHERE htt.resource_id = per.person_id
923: AND trunc(per.effective_start_date) <= trunc(SYSDATE)
924: AND trunc(per.effective_end_date) >= trunc(SYSDATE)
925: AND htt.user_id = p_user_id;

Line 1130: per_all_people_f per, hxc_temp_tcd htt

1126: DISTINCT
1127: per.full_name,
1128: htt.supervisor_name
1129: FROM
1130: per_all_people_f per, hxc_temp_tcd htt
1131: WHERE per.person_id = htt.supervisor_name
1132: AND htt.user_id = p_user_id;
1133:
1134: l_supervisor_ids VARCHARTAB;

Line 3153: FROM per_all_people_f

3149: END IF;
3150:
3151:
3152: SELECT full_name INTO l_supervisor_name
3153: FROM per_all_people_f
3154: WHERE person_id = p_supervisor_param
3155: AND trunc (sysdate) BETWEEN effective_start_date
3156: AND effective_end_date;
3157: