APPS.PER_ASG_BUS2 dependencies on PER_RECRUITMENT_ACTIVITIES

Line 2955: from per_recruitment_activities

2951: l_business_group_id per_all_assignments_f.business_group_id%TYPE;
2952: --
2953: cursor csr_val_rec_act_id is
2954: select business_group_id
2955: from per_recruitment_activities
2956: where recruitment_activity_id = p_recruitment_activity_id
2957: and p_validation_start_date
2958: between date_start
2959: and nvl(date_end, hr_api.g_eot);

Line 4105: l_rec_act_type per_recruitment_activities.type%TYPE;

4101: is
4102: --
4103: l_proc varchar2(72) := g_package||'chk_source_type';
4104: l_api_updating boolean;
4105: l_rec_act_type per_recruitment_activities.type%TYPE;
4106: --
4107: cursor csr_get_rec_act_type is
4108: select type
4109: from per_recruitment_activities

Line 4109: from per_recruitment_activities

4105: l_rec_act_type per_recruitment_activities.type%TYPE;
4106: --
4107: cursor csr_get_rec_act_type is
4108: select type
4109: from per_recruitment_activities
4110: where recruitment_activity_id = p_recruitment_activity_id;
4111: --
4112: begin
4113: hr_utility.set_location('Entering:'|| l_proc, 10);