DBA Data[Home] [Help]

APPS.HXT_BATCH_VAL dependencies on PER_PEOPLE_F

Line 44: p_person_id IN per_people_f.person_id%TYPE,

40: FUNCTION timecard_end_date (p_tim_id IN hxt_timecards_f.id%TYPE)
41: RETURN per_time_periods.end_date%TYPE;
42:
43: FUNCTION person_effective_at_tc_end (
44: p_person_id IN per_people_f.person_id%TYPE,
45: p_tim_id IN hxt_timecards.id%TYPE
46: )
47: RETURN BOOLEAN;
48:

Line 72: p_person_id IN per_people_f.person_id%TYPE,

68: p_tim_id IN hxt_timecards.id%TYPE
69: );
70:
71: FUNCTION primary_assignment_id (
72: p_person_id IN per_people_f.person_id%TYPE,
73: p_effective_date IN DATE
74: )
75: RETURN per_all_assignments_f.assignment_id%TYPE;
76:

Line 78: p_person_id IN per_people_f.person_id%TYPE,

74: )
75: RETURN per_all_assignments_f.assignment_id%TYPE;
76:
77: FUNCTION holiday_calendar_id (
78: p_person_id IN per_people_f.person_id%TYPE,
79: p_effective_date IN DATE
80: )
81: RETURN hxt_holiday_calendars.id%TYPE;
82:

Line 148: p_person_id IN per_people_f.person_id%TYPE,

144: p_hol_element_type_id OUT NOCOPY hxt_holiday_calendars.element_type_id%TYPE
145: );
146:
147: PROCEDURE get_holiday_info (
148: p_person_id IN per_people_f.person_id%TYPE,
149: p_day IN DATE,
150: p_effective_date IN DATE,
151: p_hol_hours OUT NOCOPY hxt_holiday_days.hours%TYPE,
152: p_hol_element_type_id OUT NOCOPY hxt_holiday_calendars.element_type_id%TYPE