DBA Data[Home] [Help]

APPS.PER_APPLICANT_PKG dependencies on PER_RECRUITMENT_ACTIVITY_FOR

Line 1618: from per_recruitment_activity_for

1614: l_proc varchar2(19) := 'vacancy_in_activity';
1615:
1616: cursor c1 is
1617: select 1
1618: from per_recruitment_activity_for
1619: where recruitment_activity_id = p_recruitment_activity_id
1620: and vacancy_id = p_vacancy_id ;
1621: begin
1622: --

Line 1649: from per_recruitment_activity_for r,

1645: p_date_received in date )
1646: return number is
1647: cursor c1 is
1648: select min(r.vacancy_id)
1649: from per_recruitment_activity_for r,
1650: per_all_vacancies x
1651: where r.recruitment_activity_id = p_recruitment_activity_id
1652: and r.vacancy_id = x.vacancy_id
1653: and p_date_received between x.date_from