[Home] [Help]
68: -- ----------------------------------------------------------------------------
69: --
70: -- Description
71: -- This procedure validates the assignment_id with the following checks:
72: -- - the assignment_id exists in PER_ASSIGNMENTS_F
73: -- - the assignment's business group must match the tax record's bus grp.
74: -- The record's business_group_id is also validated by checking that it
75: -- matches an existing business_group_id in PER_ASSIGNMENTS_F.
76: --
71: -- This procedure validates the assignment_id with the following checks:
72: -- - the assignment_id exists in PER_ASSIGNMENTS_F
73: -- - the assignment's business group must match the tax record's bus grp.
74: -- The record's business_group_id is also validated by checking that it
75: -- matches an existing business_group_id in PER_ASSIGNMENTS_F.
76: --
77: -- Pre-Conditions
78: -- None.
79: --
98: ) is
99: --
100: l_proc varchar2(72) := g_package||'chk_assignment_id';
101: l_dummy varchar2(1);
102: l_business_group_id per_assignments_f.business_group_id%TYPE;
103: --
104: cursor csr_bg_id is
105: select business_group_id
106: from per_assignments_f asg
102: l_business_group_id per_assignments_f.business_group_id%TYPE;
103: --
104: cursor csr_bg_id is
105: select business_group_id
106: from per_assignments_f asg
107: where asg.assignment_id = p_assignment_id
108: and p_effective_date between asg.effective_start_date
109: and asg.effective_end_date;
110: --
127: if csr_bg_id%notfound then
128: --
129: close csr_bg_id;
130: --
131: -- raise error as assignment_id not found in per_assignments_f
132: -- table.
133: --
134: hr_utility.set_message(801, 'HR_51746_ASG_INV_ASG_ID');
135: hr_utility.raise_error;