DBA Data[Home] [Help]

APPS.HR_PUMP_GET dependencies on PER_RECRUITMENT_ACTIVITIES

Line 3077: from per_recruitment_activities pra

3073: l_raid number;
3074: begin
3075: select pra.recruitment_activity_id
3076: into l_raid
3077: from per_recruitment_activities pra
3078: where pra.name = p_recruitment_activity_name
3079: and pra.business_group_id + 0 = p_business_group_id
3080: and p_effective_date between
3081: pra.date_start and nvl(pra.date_end, END_OF_TIME);