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 64: from per_all_assignments_f

60: , p_effectiveDate in date) return number as
61: cursor csrCandidateId(c_assignmentId in number
62: ,c_effectiveDate in date) is
63: select person_id
64: from per_all_assignments_f
65: where assignment_id = c_assignmentId
66: and trunc(c_effectiveDate)
67: between trunc(effective_start_date) and trunc(effective_end_date);
68: l_candidateId number;

Line 153: from per_all_assignments_f

149: , p_effectiveDate in date) return number as
150: cursor csrRecruiterId(c_assignmentId in number
151: ,c_effectiveDate in date) is
152: select recruiter_id
153: from per_all_assignments_f
154: where assignment_id = c_assignmentId
155: and trunc(c_effectiveDate)
156: between trunc(effective_start_date) and trunc(effective_end_date);
157: l_recruiterId number;