APPS.BEN_PCM_BUS dependencies on PER_ALL_ASSIGNMENTS_F

Line 109: from per_all_assignments_f asg

105: l_cm_typ_rl number;
106: --
107: cursor c_asg is
108: select asg.assignment_id
109: from per_all_assignments_f asg
110: where person_id = p_person_id and
111: primary_flag='Y' and
112: asg.assignment_type <> 'C' and
113: p_effective_date between

Line 126: -- Get assignment ID from per_all_assignments_f table.

122: cmt.effective_start_date and cmt.effective_end_date;
123: begin
124: hr_utility.set_location ('Entering '||l_proc,10);
125: --
126: -- Get assignment ID from per_all_assignments_f table.
127: --
128: open c_asg;
129: fetch c_asg into l_assignment_id;
130: -- if c_asg%notfound then