APPS.IRC_PARTY_API dependencies on IRC_AGENCY_VACANCIES

Line 1952: , IRC_AGENCY_VACANCIES AGV1

1948: --
1949: cursor csr_application_count(p_vacancy_id number, p_effective_date date) is
1950: select count(*)
1951: from per_all_assignments_f paaf
1952: , IRC_AGENCY_VACANCIES AGV1
1953: ,per_all_people_f per1
1954: ,irc_notification_preferences prefs
1955: where paaf.vacancy_id = p_vacancy_id and paaf.assignment_type = 'A'
1956: and p_effective_date between PAAF.EFFECTIVE_START_DATE

Line 1969: from IRC_AGENCY_VACANCIES AGV

1965: and nvl(agv1.end_date,p_effective_date);
1966: --
1967: cursor csr_application_count_limit(p_vacancy_id number) is
1968: select AGV.MAX_ALLOWED_APPLICANTS
1969: from IRC_AGENCY_VACANCIES AGV
1970: where agv.vacancy_id = p_vacancy_id
1971: and AGV.AGENCY_ID = FND_PROFILE.VALUE('IRC_AGENCY_NAME');
1972: --
1973: l_application_count_limit IRC_AGENCY_VACANCIES.MAX_ALLOWED_APPLICANTS%TYPE;

Line 1973: l_application_count_limit IRC_AGENCY_VACANCIES.MAX_ALLOWED_APPLICANTS%TYPE;

1969: from IRC_AGENCY_VACANCIES AGV
1970: where agv.vacancy_id = p_vacancy_id
1971: and AGV.AGENCY_ID = FND_PROFILE.VALUE('IRC_AGENCY_NAME');
1972: --
1973: l_application_count_limit IRC_AGENCY_VACANCIES.MAX_ALLOWED_APPLICANTS%TYPE;
1974: l_application_count Number;
1975: l_agency_id IRC_AGENCY_VACANCIES.AGENCY_ID%TYPE;
1976: begin
1977: --

Line 1975: l_agency_id IRC_AGENCY_VACANCIES.AGENCY_ID%TYPE;

1971: and AGV.AGENCY_ID = FND_PROFILE.VALUE('IRC_AGENCY_NAME');
1972: --
1973: l_application_count_limit IRC_AGENCY_VACANCIES.MAX_ALLOWED_APPLICANTS%TYPE;
1974: l_application_count Number;
1975: l_agency_id IRC_AGENCY_VACANCIES.AGENCY_ID%TYPE;
1976: begin
1977: --
1978: -- only check if Agency profile is set
1979: --