APPS.HXT_BATCH_VAL dependencies on PER_PEOPLE_F

Line 301: p_person_id IN per_people_f.person_id%TYPE,

297: RETURN l_tc_end_dt;
298: END timecard_end_date;
299:
300: FUNCTION person_effective_at_tc_end (
301: p_person_id IN per_people_f.person_id%TYPE,
302: p_tim_id IN hxt_timecards.id%TYPE
303: )
304: RETURN BOOLEAN
305: IS

Line 310: p_effective_date per_people_f.effective_end_date%TYPE,

306: l_proc VARCHAR2 (72);
307:
308:
309: CURSOR csr_person_effective (
310: p_effective_date per_people_f.effective_end_date%TYPE,
311: p_person_id per_people_f.person_id%TYPE
312: )
313: IS
314: SELECT 1

Line 311: p_person_id per_people_f.person_id%TYPE

307:
308:
309: CURSOR csr_person_effective (
310: p_effective_date per_people_f.effective_end_date%TYPE,
311: p_person_id per_people_f.person_id%TYPE
312: )
313: IS
314: SELECT 1
315: FROM per_people_f ppf

Line 315: FROM per_people_f ppf

311: p_person_id per_people_f.person_id%TYPE
312: )
313: IS
314: SELECT 1
315: FROM per_people_f ppf
316: WHERE person_id = p_person_id
317: AND p_effective_date BETWEEN ppf.effective_start_date
318: AND ppf.effective_end_date;
319:

Line 322: l_eff_dt per_people_f.effective_end_date%TYPE;

318: AND ppf.effective_end_date;
319:
320: l_person_effective BOOLEAN;
321: l_found_person NUMBER;
322: l_eff_dt per_people_f.effective_end_date%TYPE;
323: BEGIN
324: g_debug :=hr_utility.debug_enabled;
325: if g_debug then
326: l_proc := g_package

Line 547: p_person_id IN per_people_f.person_id%TYPE,

543: end if;
544: END excess_pto;
545:
546: FUNCTION primary_assignment_id (
547: p_person_id IN per_people_f.person_id%TYPE,
548: p_effective_date IN DATE
549: )
550: RETURN per_all_assignments_f.assignment_id%TYPE
551: IS

Line 555: p_person_id per_people_f.person_id%TYPE,

551: IS
552: l_proc VARCHAR2 (72) ;
553:
554: CURSOR csr_prim_asg_id (
555: p_person_id per_people_f.person_id%TYPE,
556: p_effective_date DATE
557: )
558: IS
559:

Line 599: p_person_id IN per_people_f.person_id%TYPE,

595: RETURN l_prim_asg_id;
596: END primary_assignment_id;
597:
598: FUNCTION holiday_calendar_id (
599: p_person_id IN per_people_f.person_id%TYPE,
600: p_effective_date IN DATE
601: )
602: RETURN hxt_holiday_calendars.id%TYPE
603: IS

Line 1157: p_person_id IN per_people_f.person_id%TYPE,

1153: end if;
1154: END get_holiday_info;
1155:
1156: PROCEDURE get_holiday_info (
1157: p_person_id IN per_people_f.person_id%TYPE,
1158: p_day IN DATE,
1159: p_effective_date IN DATE,
1160: p_hol_hours OUT NOCOPY hxt_holiday_days.hours%TYPE,
1161: p_hol_element_type_id OUT NOCOPY hxt_holiday_calendars.element_type_id%TYPE