APPS.IRC_PARTY_API dependencies on IRC_AGENCY_VACANCIES

Line 1927: , IRC_AGENCY_VACANCIES AGV1

1923: --
1924: cursor csr_application_count(p_vacancy_id number, p_effective_date date) is
1925: select count(*)
1926: from per_all_assignments_f paaf
1927: , IRC_AGENCY_VACANCIES AGV1
1928: ,per_all_people_f per1
1929: ,irc_notification_preferences prefs
1930: where paaf.vacancy_id = p_vacancy_id and paaf.assignment_type = 'A'
1931: and p_effective_date between PAAF.EFFECTIVE_START_DATE

Line 1944: from IRC_AGENCY_VACANCIES AGV

1940: and nvl(agv1.end_date,p_effective_date);
1941: --
1942: cursor csr_application_count_limit(p_vacancy_id number) is
1943: select AGV.MAX_ALLOWED_APPLICANTS
1944: from IRC_AGENCY_VACANCIES AGV
1945: where agv.vacancy_id = p_vacancy_id
1946: and AGV.AGENCY_ID = FND_PROFILE.VALUE('IRC_AGENCY_NAME');
1947: --
1948: l_application_count_limit IRC_AGENCY_VACANCIES.MAX_ALLOWED_APPLICANTS%TYPE;

Line 1948: l_application_count_limit IRC_AGENCY_VACANCIES.MAX_ALLOWED_APPLICANTS%TYPE;

1944: from IRC_AGENCY_VACANCIES AGV
1945: where agv.vacancy_id = p_vacancy_id
1946: and AGV.AGENCY_ID = FND_PROFILE.VALUE('IRC_AGENCY_NAME');
1947: --
1948: l_application_count_limit IRC_AGENCY_VACANCIES.MAX_ALLOWED_APPLICANTS%TYPE;
1949: l_application_count Number;
1950: l_agency_id IRC_AGENCY_VACANCIES.AGENCY_ID%TYPE;
1951: begin
1952: --

Line 1950: l_agency_id IRC_AGENCY_VACANCIES.AGENCY_ID%TYPE;

1946: and AGV.AGENCY_ID = FND_PROFILE.VALUE('IRC_AGENCY_NAME');
1947: --
1948: l_application_count_limit IRC_AGENCY_VACANCIES.MAX_ALLOWED_APPLICANTS%TYPE;
1949: l_application_count Number;
1950: l_agency_id IRC_AGENCY_VACANCIES.AGENCY_ID%TYPE;
1951: begin
1952: --
1953: -- only check if Agency profile is set
1954: --