[Home] [Help]
30: from per_business_groups_perf pbg
31: where pbg.business_group_id =
32: (select distinct asg.business_group_id
33: from irc_assignment_details_f iad
34: , per_all_assignments_f asg
35: where iad.assignment_details_id = p_assignment_details_id
36: and iad.assignment_id = asg.assignment_id);
37: --
38: -- Declare local variables
103: from per_business_groups_perf pbg
104: where pbg.business_group_id =
105: (select distinct asg.business_group_id
106: from irc_assignment_details_f iad
107: , per_all_assignments_f asg
108: where iad.assignment_details_id = p_assignment_details_id
109: and iad.assignment_id = asg.assignment_id);
110: --
111: -- Declare local variables
309: );
310: --
311: If ((nvl(p_assignment_id, hr_api.g_number) <> hr_api.g_number) and
312: NOT (dt_api.check_min_max_dates
313: (p_base_table_name => 'per_all_assignments_f'
314: ,p_base_key_column => 'ASSIGNMENT_ID'
315: ,p_base_key_value => p_assignment_id
316: ,p_from_date => p_validation_start_date
317: ,p_to_date => p_validation_end_date))) Then
471: --
472: l_proc varchar2(72) := g_package||'chk_attempt_id';
473: l_api_updating boolean;
474: l_dummy varchar2(1);
475: l_assignment_type per_all_assignments_f.assignment_type%TYPE;
476: --
477: cursor csr_assignment_type(p_assignment_id number, p_effective_date date) is
478: select assignment_type
479: from per_all_assignments_f
475: l_assignment_type per_all_assignments_f.assignment_type%TYPE;
476: --
477: cursor csr_assignment_type(p_assignment_id number, p_effective_date date) is
478: select assignment_type
479: from per_all_assignments_f
480: where assignment_id = p_assignment_id and
481: p_effective_date between effective_start_date and effective_end_date;
482: --
483: cursor attempt_exists(p_attempt_id number) is