DBA Data[Home] [Help]

APPS.PER_ABV_BUS dependencies on PER_ASSIGNMENTS_F

Line 260: -- per_assignments_f and is in the same business group.

256: -- {Start Of Comments}
257: --
258: -- Description:
259: -- This procedure is used to ensure that the assignment exists in
260: -- per_assignments_f and is in the same business group.
261: --
262: procedure chk_assignment_id(p_assignment_id number
263: ,p_business_group_id number
264: ,p_effective_date date) is

Line 267: from per_assignments_f

263: ,p_business_group_id number
264: ,p_effective_date date) is
265: cursor c is
266: select 'x'
267: from per_assignments_f
268: where assignment_id = p_assignment_id
269: and p_effective_date between effective_start_date and effective_end_date
270: and business_group_id = p_business_group_id;
271: