DBA Data[Home] [Help]

APPS.HR_PUMP_GET dependencies on PER_RECRUITMENT_ACTIVITIES

Line 3050: from per_recruitment_activities pra

3046: l_raid number;
3047: begin
3048: select pra.recruitment_activity_id
3049: into l_raid
3050: from per_recruitment_activities pra
3051: where pra.name = p_recruitment_activity_name
3052: and pra.business_group_id + 0 = p_business_group_id
3053: and p_effective_date between
3054: pra.date_start and nvl(pra.date_end, END_OF_TIME);