APPS.HR_BIS_ORG_PERF dependencies on PER_ALL_ASSIGNMENTS_F

Line 237: from per_all_assignments_f asg

233:
234: /* return a row if the assignment is active on cp_effective_date */
235: cursor cur_check_asg_active(cp_assignment_id number, cp_effective_date date) is
236: select 1
237: from per_all_assignments_f asg
238: where asg.assignment_id = cp_assignment_id
239: and cp_effective_date between asg.effective_start_date and asg.effective_end_date;
240:
241: l_check_asg number;