APPS.HRI_OPL_SUPH_EVENTS dependencies on PER_ALL_ASSIGNMENTS_F

Line 138: ,per_all_assignments_f asg

134: ,asg.assignment_type
135: ,asg.business_group_id
136: FROM
137: hri_eq_sprvsr_hrchy_chgs eq
138: ,per_all_assignments_f asg
139: ,per_assignment_status_types ast
140: WHERE asg.assignment_type IN ('E', 'C')
141: AND asg.primary_flag = 'Y'
142: AND eq.assignment_id BETWEEN p_start_asg_id AND p_end_asg_id

Line 237: per_all_assignments_f asg

233: ,asg.assignment_status_type_id
234: ,asg.assignment_type
235: ,asg.business_group_id
236: FROM
237: per_all_assignments_f asg
238: ,per_assignment_status_types ast
239: WHERE asg.assignment_type IN ('E', 'C')
240: AND asg.primary_flag = 'Y'
241: AND asg.assignment_id BETWEEN p_start_asg_id AND p_end_asg_id

Line 332: per_all_assignments_f asg

328: ,g_user
329: ,g_user
330: ,g_sysdate
331: FROM
332: per_all_assignments_f asg
333: ,per_assignment_status_types ast
334: ,per_periods_of_service pos
335: ,per_periods_of_placement ppp
336: WHERE asg.assignment_type IN ('E', 'C')

Line 404: FROM per_all_assignments_f asg

400: -- Set the SQL statement for the entire range
401: p_sqlstr :=
402: 'SELECT /*+ PARALLEL(asg, DEFAULT, DEFAULT) */
403: DISTINCT assignment_id object_id
404: FROM per_all_assignments_f asg
405: WHERE assignment_type IN (''E'', ''C'')
406: AND primary_flag = ''Y''
407: AND effective_end_date >= to_date(''' ||
408: to_char(g_refresh_start_date, 'DD-MM-YYYY') ||

Line 508: FROM per_all_assignments_f;

504: BEGIN
505:
506: -- get max assignment id
507: SELECT max(assignment_id) INTO l_end_asg_id
508: FROM per_all_assignments_f;
509:
510: -- Set globals
511: g_refresh_start_date := l_from_date;
512: g_full_refresh := p_full_refresh_flag;