APPS.HR_DELETE dependencies on PER_RECRUITMENT_ACTIVITIES

Line 740: PER_RECRUITMENT_ACTIVITIES.business_group_id%TYPE)

736: WHERE business_group_id = c_business_group_id);
737: --
738: cursor csr_get_rca
739: (c_business_group_id
740: PER_RECRUITMENT_ACTIVITIES.business_group_id%TYPE)
741: is
742: SELECT null
743: FROM sys.dual
744: WHERE exists(select null

Line 745: FROM PER_RECRUITMENT_ACTIVITIES

741: is
742: SELECT null
743: FROM sys.dual
744: WHERE exists(select null
745: FROM PER_RECRUITMENT_ACTIVITIES
746: WHERE business_group_id = c_business_group_id);
747: --
748: cursor csr_get_req
749: (c_business_group_id

Line 1048: DELETE FROM per_recruitment_activities

1044: DELETE FROM per_recruitment_activity_for
1045: WHERE business_group_id = p_business_group_id;
1046: hr_utility.set_location(l_proc,280);
1047: --
1048: DELETE FROM per_recruitment_activities
1049: WHERE business_group_id = p_business_group_id;
1050: hr_utility.set_location(l_proc,290);
1051: --
1052: end if;