APPS.IRC_NOTIFICATION_DATA_PKG dependencies on PER_ALL_ASSIGNMENTS_F

Line 36: from per_all_assignments_f

32: , p_effectiveDate in date) return number as
33: cursor csrVacancyId(c_assignmentId in number
34: ,c_effectiveDate in date) is
35: select vacancy_id
36: from per_all_assignments_f
37: where assignment_id = c_assignmentId
38: and trunc(c_effectiveDate)
39: between trunc(effective_start_date) and trunc(effective_end_date);
40: l_vacancyId number;

Line 65: from per_all_assignments_f

61: , p_event_name in varchar2 default null) return number as
62: cursor csrCandidateId(c_assignmentId in number
63: ,c_effectiveDate in date) is
64: select person_id
65: from per_all_assignments_f
66: where assignment_id = c_assignmentId
67: and trunc(c_effectiveDate)
68: between trunc(effective_start_date) and trunc(effective_end_date);
69: cursor csrTermntdCandidateId(c_assignmentId in number) is

Line 71: from per_all_assignments_f

67: and trunc(c_effectiveDate)
68: between trunc(effective_start_date) and trunc(effective_end_date);
69: cursor csrTermntdCandidateId(c_assignmentId in number) is
70: select person_id
71: from per_all_assignments_f
72: where assignment_id = c_assignmentId
73: and rownum<2;
74:
75: l_candidateId number;

Line 165: from per_all_assignments_f

161: , p_effectiveDate in date) return number as
162: cursor csrRecruiterId(c_assignmentId in number
163: ,c_effectiveDate in date) is
164: select recruiter_id
165: from per_all_assignments_f
166: where assignment_id = c_assignmentId
167: and trunc(c_effectiveDate)
168: between trunc(effective_start_date) and trunc(effective_end_date);
169: l_recruiterId number;