APPS.HXT_BATCH_VAL dependencies on PER_PEOPLE_F

Line 295: p_person_id IN per_people_f.person_id%TYPE,

291: RETURN l_tc_end_dt;
292: END timecard_end_date;
293:
294: FUNCTION person_effective_at_tc_end (
295: p_person_id IN per_people_f.person_id%TYPE,
296: p_tim_id IN hxt_timecards.id%TYPE
297: )
298: RETURN BOOLEAN
299: IS

Line 304: p_effective_date per_people_f.effective_end_date%TYPE,

300: l_proc VARCHAR2 (72);
301:
302:
303: CURSOR csr_person_effective (
304: p_effective_date per_people_f.effective_end_date%TYPE,
305: p_person_id per_people_f.person_id%TYPE
306: )
307: IS
308: SELECT 1

Line 305: p_person_id per_people_f.person_id%TYPE

301:
302:
303: CURSOR csr_person_effective (
304: p_effective_date per_people_f.effective_end_date%TYPE,
305: p_person_id per_people_f.person_id%TYPE
306: )
307: IS
308: SELECT 1
309: FROM per_people_f ppf

Line 309: FROM per_people_f ppf

305: p_person_id per_people_f.person_id%TYPE
306: )
307: IS
308: SELECT 1
309: FROM per_people_f ppf
310: WHERE person_id = p_person_id
311: AND p_effective_date BETWEEN ppf.effective_start_date
312: AND ppf.effective_end_date;
313:

Line 316: l_eff_dt per_people_f.effective_end_date%TYPE;

312: AND ppf.effective_end_date;
313:
314: l_person_effective BOOLEAN;
315: l_found_person NUMBER;
316: l_eff_dt per_people_f.effective_end_date%TYPE;
317: BEGIN
318: g_debug :=hr_utility.debug_enabled;
319: if g_debug then
320: l_proc := g_package

Line 485: p_person_id IN per_people_f.person_id%TYPE,

481: end if;
482: END excess_pto;
483:
484: FUNCTION primary_assignment_id (
485: p_person_id IN per_people_f.person_id%TYPE,
486: p_effective_date IN DATE
487: )
488: RETURN per_all_assignments_f.assignment_id%TYPE
489: IS

Line 493: p_person_id per_people_f.person_id%TYPE,

489: IS
490: l_proc VARCHAR2 (72) ;
491:
492: CURSOR csr_prim_asg_id (
493: p_person_id per_people_f.person_id%TYPE,
494: p_effective_date DATE
495: )
496: IS
497:

Line 537: p_person_id IN per_people_f.person_id%TYPE,

533: RETURN l_prim_asg_id;
534: END primary_assignment_id;
535:
536: FUNCTION holiday_calendar_id (
537: p_person_id IN per_people_f.person_id%TYPE,
538: p_effective_date IN DATE
539: )
540: RETURN hxt_holiday_calendars.id%TYPE
541: IS

Line 1036: p_person_id IN per_people_f.person_id%TYPE,

1032: end if;
1033: END get_holiday_info;
1034:
1035: PROCEDURE get_holiday_info (
1036: p_person_id IN per_people_f.person_id%TYPE,
1037: p_day IN DATE,
1038: p_effective_date IN DATE,
1039: p_hol_hours OUT NOCOPY hxt_holiday_days.hours%TYPE,
1040: p_hol_element_type_id OUT NOCOPY hxt_holiday_calendars.element_type_id%TYPE