APPS.HXT_BATCH_VAL dependencies on PER_ALL_ASSIGNMENTS_F

Line 75: RETURN per_all_assignments_f.assignment_id%TYPE;

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:
77: FUNCTION holiday_calendar_id (
78: p_person_id IN per_people_f.person_id%TYPE,
79: p_effective_date IN DATE

Line 84: p_assignment_id IN per_all_assignments_f.assignment_id%TYPE,

80: )
81: RETURN hxt_holiday_calendars.id%TYPE;
82:
83: FUNCTION holiday_calendar_id (
84: p_assignment_id IN per_all_assignments_f.assignment_id%TYPE,
85: p_effective_date IN DATE
86: )
87: RETURN hxt_holiday_calendars.id%TYPE;
88:

Line 120: p_asg_id IN per_all_assignments_f.assignment_id%TYPE,

116: )
117: RETURN VARCHAR2; -- per_business_groups.legislation_code%TYPE;
118:
119: FUNCTION legislation_code (
120: p_asg_id IN per_all_assignments_f.assignment_id%TYPE,
121: p_effective_date IN DATE
122: )
123: RETURN per_business_groups.legislation_code%TYPE;
124:

Line 126: p_asg_id IN per_all_assignments_f.assignment_id%TYPE,

122: )
123: RETURN per_business_groups.legislation_code%TYPE;
124:
125: FUNCTION assignment_is_active (
126: p_asg_id IN per_all_assignments_f.assignment_id%TYPE,
127: p_effective_date IN DATE
128: )
129: RETURN BOOLEAN;
130:

Line 134: p_assignment_id IN per_all_assignments_f.assignment_id%TYPE,

130:
131: PROCEDURE inactive_emp_tcard (
132: p_batch_id IN NUMBER,
133: p_person_id IN hxt_timecards.for_person_id%TYPE,
134: p_assignment_id IN per_all_assignments_f.assignment_id%TYPE,
135: p_period_id IN hxt_timecards.time_period_id%TYPE,
136: p_tim_id IN hxt_timecards.id%TYPE,
137: p_day IN DATE
138: );

Line 184: p_assignment_id IN per_all_assignments_f.assignment_id%TYPE,

180: );
181:
182: FUNCTION element_link (
183: p_element_type_id IN pay_element_types_f.element_type_id%TYPE,
184: p_assignment_id IN per_all_assignments_f.assignment_id%TYPE,
185: p_effective_date IN DATE
186: )
187: RETURN pay_element_links_f.element_link_id%TYPE;
188:

Line 191: p_assignment_id IN per_all_assignments_f.assignment_id%TYPE,

187: RETURN pay_element_links_f.element_link_id%TYPE;
188:
189: FUNCTION element_linked (
190: p_element_type_id IN pay_element_types_f.element_type_id%TYPE,
191: p_assignment_id IN per_all_assignments_f.assignment_id%TYPE,
192: p_effective_date IN DATE
193: )
194: RETURN BOOLEAN;
195:

Line 200: p_assignment_id IN per_all_assignments_f.assignment_id%TYPE,

196: FUNCTION valid_for_summing (
197: p_element_id IN pay_element_types_f.element_type_id%TYPE,
198: p_earnings_category IN hxt_add_elem_info_f.earning_category%TYPE,
199: p_day IN DATE,
200: p_assignment_id IN per_all_assignments_f.assignment_id%TYPE,
201: p_hol_cal_id IN hxt_holiday_calendars.id%TYPE,
202: p_valid_earn_cat1 IN hxt_add_elem_info_f.earning_category%TYPE
203: DEFAULT NULL,
204: p_valid_earn_cat2 IN hxt_add_elem_info_f.earning_category%TYPE

Line 222: p_assignment_id IN per_all_assignments_f.assignment_id%TYPE,

218:
219: FUNCTION sum_valid_det_hours (
220: p_tim_id IN hxt_timecards.id%TYPE,
221: p_day IN DATE,
222: p_assignment_id IN per_all_assignments_f.assignment_id%TYPE,
223: p_hol_cal_id IN hxt_holiday_calendars.id%TYPE
224: )
225: RETURN NUMBER;
226:

Line 230: p_assignment_id IN per_all_assignments_f.assignment_id%TYPE,

226:
227: PROCEDURE day_over_24 (
228: p_batch_id IN NUMBER,
229: p_person_id IN hxt_timecards.for_person_id%TYPE,
230: p_assignment_id IN per_all_assignments_f.assignment_id%TYPE,
231: p_period_id IN hxt_timecards.time_period_id%TYPE,
232: p_tim_id IN hxt_timecards.id%TYPE,
233: p_day IN DATE,
234: p_hol_cal_id IN hxt_holiday_calendars.id%TYPE