APPS.BEN_PER_ASG_ELIG dependencies on PER_ALL_ASSIGNMENTS_F

Line 45: from per_all_assignments_f asg

41: and effective_end_date;
42:
43: cursor c_asg(c_assignment_id number) is
44: select person_id
45: from per_all_assignments_f asg
46: where assignment_id = c_assignment_id
47: and p_effective_date between effective_start_date
48: and effective_end_date;
49:

Line 63: from per_all_assignments_f paf

59: order by decode(mndtry_flag,'Y',1,2);
60:
61: cursor c_asg_by_type is
62: select paf.assignment_id
63: from per_all_assignments_f paf
64: where paf.person_id = p_person_id
65: and decode(substr(p_assignment_type,3,1),'P','Y',paf.primary_flag) = paf.primary_flag
66: and decode(substr(p_assignment_type,1,1),'L',paf.assignment_type,substr(p_assignment_type,1,1)) = paf.assignment_type
67: and paf.business_group_id = p_business_group_id

Line 208: hr_utility.set_message_token('TABLE_NAME', 'per_all_assignments_f');

204:
205: if l_person_id is null then
206: hr_utility.set_location('person_id is null and no assignment found',10);
207: hr_utility.set_message(801, 'HR_7180_DT_NO_ROW_EXIST');
208: hr_utility.set_message_token('TABLE_NAME', 'per_all_assignments_f');
209: hr_utility.set_message_token('SESSION_DATE', to_char(p_effective_date));
210: hr_utility.raise_error;
211: end if;
212: else

Line 476: from per_all_assignments_f asg

472: pragma autonomous_transaction;
473:
474: cursor c_asg(c_assignment_id number) is
475: select person_id
476: from per_all_assignments_f asg
477: where assignment_id = c_assignment_id
478: and p_effective_date between effective_start_date
479: and effective_end_date;
480: