APPS.HXT_BATCH_VAL dependencies on PER_ALL_ASSIGNMENTS_F

Line 99: RETURN per_all_assignments_f.assignment_id%TYPE;

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:
101: FUNCTION holiday_calendar_id (
102: p_person_id IN per_people_f.person_id%TYPE,
103: p_effective_date IN DATE

Line 108: p_assignment_id IN per_all_assignments_f.assignment_id%TYPE,

104: )
105: RETURN hxt_holiday_calendars.id%TYPE;
106:
107: FUNCTION holiday_calendar_id (
108: p_assignment_id IN per_all_assignments_f.assignment_id%TYPE,
109: p_effective_date IN DATE
110: )
111: RETURN hxt_holiday_calendars.id%TYPE;
112:

Line 144: p_asg_id IN per_all_assignments_f.assignment_id%TYPE,

140: )
141: RETURN VARCHAR2; -- per_business_groups.legislation_code%TYPE;
142:
143: FUNCTION legislation_code (
144: p_asg_id IN per_all_assignments_f.assignment_id%TYPE,
145: p_effective_date IN DATE
146: )
147: RETURN per_business_groups.legislation_code%TYPE;
148:

Line 150: p_asg_id IN per_all_assignments_f.assignment_id%TYPE,

146: )
147: RETURN per_business_groups.legislation_code%TYPE;
148:
149: FUNCTION assignment_is_active (
150: p_asg_id IN per_all_assignments_f.assignment_id%TYPE,
151: p_effective_date IN DATE
152: )
153: RETURN BOOLEAN;
154:

Line 158: p_assignment_id IN per_all_assignments_f.assignment_id%TYPE,

154:
155: PROCEDURE inactive_emp_tcard (
156: p_batch_id IN NUMBER,
157: p_person_id IN hxt_timecards.for_person_id%TYPE,
158: p_assignment_id IN per_all_assignments_f.assignment_id%TYPE,
159: p_period_id IN hxt_timecards.time_period_id%TYPE,
160: p_tim_id IN hxt_timecards.id%TYPE,
161: p_day IN DATE
162: );

Line 208: p_assignment_id IN per_all_assignments_f.assignment_id%TYPE,

204: );
205:
206: FUNCTION element_link (
207: p_element_type_id IN pay_element_types_f.element_type_id%TYPE,
208: p_assignment_id IN per_all_assignments_f.assignment_id%TYPE,
209: p_effective_date IN DATE
210: )
211: RETURN pay_element_links_f.element_link_id%TYPE;
212:

Line 215: p_assignment_id IN per_all_assignments_f.assignment_id%TYPE,

211: RETURN pay_element_links_f.element_link_id%TYPE;
212:
213: FUNCTION element_linked (
214: p_element_type_id IN pay_element_types_f.element_type_id%TYPE,
215: p_assignment_id IN per_all_assignments_f.assignment_id%TYPE,
216: p_effective_date IN DATE
217: )
218: RETURN BOOLEAN;
219:

Line 224: p_assignment_id IN per_all_assignments_f.assignment_id%TYPE,

220: FUNCTION valid_for_summing (
221: p_element_id IN pay_element_types_f.element_type_id%TYPE,
222: p_earnings_category IN hxt_add_elem_info_f.earning_category%TYPE,
223: p_day IN DATE,
224: p_assignment_id IN per_all_assignments_f.assignment_id%TYPE,
225: p_hol_cal_id IN hxt_holiday_calendars.id%TYPE,
226: p_valid_earn_cat1 IN hxt_add_elem_info_f.earning_category%TYPE
227: DEFAULT NULL,
228: p_valid_earn_cat2 IN hxt_add_elem_info_f.earning_category%TYPE

Line 246: p_assignment_id IN per_all_assignments_f.assignment_id%TYPE,

242:
243: FUNCTION sum_valid_det_hours (
244: p_tim_id IN hxt_timecards.id%TYPE,
245: p_day IN DATE,
246: p_assignment_id IN per_all_assignments_f.assignment_id%TYPE,
247: p_hol_cal_id IN hxt_holiday_calendars.id%TYPE
248: )
249: RETURN NUMBER;
250:

Line 254: p_assignment_id IN per_all_assignments_f.assignment_id%TYPE,

250:
251: PROCEDURE day_over_24 (
252: p_batch_id IN NUMBER,
253: p_person_id IN hxt_timecards.for_person_id%TYPE,
254: p_assignment_id IN per_all_assignments_f.assignment_id%TYPE,
255: p_period_id IN hxt_timecards.time_period_id%TYPE,
256: p_tim_id IN hxt_timecards.id%TYPE,
257: p_day IN DATE,
258: p_hol_cal_id IN hxt_holiday_calendars.id%TYPE