DBA Data[Home] [Help]

APPS.PER_APPLICANT_PKG dependencies on PER_RECRUITMENT_ACTIVITY_FOR

Line 1462: from per_recruitment_activity_for

1458: l_return_value boolean := FALSE ;
1459: l_dummy number ;
1460: cursor c1 is
1461: select 1
1462: from per_recruitment_activity_for
1463: where recruitment_activity_id = p_recruitment_activity_id
1464: and vacancy_id = p_vacancy_id ;
1465: begin
1466: --

Line 1482: from per_recruitment_activity_for r,

1478: p_date_received in date )
1479: return number is
1480: cursor c1 is
1481: select min(r.vacancy_id)
1482: from per_recruitment_activity_for r,
1483: per_all_vacancies x
1484: where r.recruitment_activity_id = p_recruitment_activity_id
1485: and r.vacancy_id = x.vacancy_id
1486: and p_date_received between x.date_from