APPS.PER_ASG_BUS2 dependencies on PER_RECRUITMENT_ACTIVITIES

Line 2995: from per_recruitment_activities

2991: l_business_group_id per_all_assignments_f.business_group_id%TYPE;
2992: --
2993: cursor csr_val_rec_act_id is
2994: select business_group_id
2995: from per_recruitment_activities
2996: where recruitment_activity_id = p_recruitment_activity_id
2997: and p_validation_start_date
2998: between date_start
2999: and nvl(date_end, hr_api.g_eot);

Line 4145: l_rec_act_type per_recruitment_activities.type%TYPE;

4141: is
4142: --
4143: l_proc varchar2(72) := g_package||'chk_source_type';
4144: l_api_updating boolean;
4145: l_rec_act_type per_recruitment_activities.type%TYPE;
4146: --
4147: cursor csr_get_rec_act_type is
4148: select type
4149: from per_recruitment_activities

Line 4149: from per_recruitment_activities

4145: l_rec_act_type per_recruitment_activities.type%TYPE;
4146: --
4147: cursor csr_get_rec_act_type is
4148: select type
4149: from per_recruitment_activities
4150: where recruitment_activity_id = p_recruitment_activity_id;
4151: --
4152: begin
4153: hr_utility.set_location('Entering:'|| l_proc, 10);