APPS.HR_DELETE dependencies on PER_CAREER_PATHS

Line 780: PER_CAREER_PATHS.business_group_id%TYPE)

776: WHERE business_group_id = c_business_group_id);
777: --
778: cursor csr_get_crp
779: (c_business_group_id
780: PER_CAREER_PATHS.business_group_id%TYPE)
781: is
782: SELECT null
783: FROM sys.dual
784: WHERE exists(select null

Line 785: FROM PER_CAREER_PATHS

781: is
782: SELECT null
783: FROM sys.dual
784: WHERE exists(select null
785: FROM PER_CAREER_PATHS
786: WHERE business_group_id = c_business_group_id);
787: --
788: cursor csr_get_pst
789: (c_business_group_id

Line 1010: DELETE FROM per_career_paths

1006: DELETE FROM per_career_path_elements
1007: WHERE business_group_id = p_business_group_id;
1008: hr_utility.set_location(l_proc,60);
1009: --
1010: DELETE FROM per_career_paths
1011: WHERE business_group_id = p_business_group_id;
1012: hr_utility.set_location(l_proc,70);
1013: --
1014: end if;