APPS.HR_DELETE dependencies on FF_USER_ENTITIES

Line 489: (c_business_group_id ff_user_entities.business_group_id%TYPE)

485: --
486: l_exists varchar2(1);
487: --
488: cursor csr_get_ff_user_ents
489: (c_business_group_id ff_user_entities.business_group_id%TYPE)
490: is
491: SELECT null
492: FROM ff_user_entities
493: WHERE business_group_id = c_business_group_id;

Line 492: FROM ff_user_entities

488: cursor csr_get_ff_user_ents
489: (c_business_group_id ff_user_entities.business_group_id%TYPE)
490: is
491: SELECT null
492: FROM ff_user_entities
493: WHERE business_group_id = c_business_group_id;
494: --
495: begin
496: hr_utility.set_location('Entering: '||l_proc, 10);

Line 504: DELETE FROM ff_user_entities

500: open csr_get_ff_user_ents(p_business_group_id);
501: fetch csr_get_ff_user_ents into l_exists;
502: if csr_get_ff_user_ents%found then
503: --
504: DELETE FROM ff_user_entities
505: WHERE business_group_id = p_business_group_id;
506: hr_utility.set_location(l_proc, 20);
507: --
508: end if;