DBA Data[Home] [Help]

APPS.HXT_BATCH_VAL dependencies on PER_PEOPLE_F

Line 68: p_person_id IN per_people_f.person_id%TYPE,

64: FUNCTION timecard_end_date (p_tim_id IN hxt_timecards_f.id%TYPE)
65: RETURN per_time_periods.end_date%TYPE;
66:
67: FUNCTION person_effective_at_tc_end (
68: p_person_id IN per_people_f.person_id%TYPE,
69: p_tim_id IN hxt_timecards.id%TYPE
70: )
71: RETURN BOOLEAN;
72:

Line 96: p_person_id IN per_people_f.person_id%TYPE,

92: p_tim_id IN hxt_timecards.id%TYPE
93: );
94:
95: FUNCTION primary_assignment_id (
96: p_person_id IN per_people_f.person_id%TYPE,
97: p_effective_date IN DATE
98: )
99: RETURN per_all_assignments_f.assignment_id%TYPE;
100:

Line 102: p_person_id IN per_people_f.person_id%TYPE,

98: )
99: RETURN per_all_assignments_f.assignment_id%TYPE;
100:
101: FUNCTION holiday_calendar_id (
102: p_person_id IN per_people_f.person_id%TYPE,
103: p_effective_date IN DATE
104: )
105: RETURN hxt_holiday_calendars.id%TYPE;
106:

Line 172: p_person_id IN per_people_f.person_id%TYPE,

168: p_hol_element_type_id OUT NOCOPY hxt_holiday_calendars.element_type_id%TYPE
169: );
170:
171: PROCEDURE get_holiday_info (
172: p_person_id IN per_people_f.person_id%TYPE,
173: p_day IN DATE,
174: p_effective_date IN DATE,
175: p_hol_hours OUT NOCOPY hxt_holiday_days.hours%TYPE,
176: p_hol_element_type_id OUT NOCOPY hxt_holiday_calendars.element_type_id%TYPE