DBA Data[Home] [Help]

APPS.HR_DELETE dependencies on PER_ALL_ASSIGNMENTS_F

Line 690: FROM per_all_assignments_f

686: is
687: SELECT null
688: FROM sys.dual
689: WHERE exists(select null
690: FROM per_all_assignments_f
691: WHERE business_group_id = c_business_group_id);
692: --
693: cursor csr_get_ast
694: (c_business_group_id per_assignments_f.business_group_id%TYPE)

Line 986: -- WWBUG 1833930. Changed to use base table per_all_assignments_f

982: DELETE FROM per_secondary_ass_statuses
983: WHERE business_group_id = p_business_group_id;
984: hr_utility.set_location(l_proc, 250);
985: --
986: -- WWBUG 1833930. Changed to use base table per_all_assignments_f
987: --
988: DELETE FROM per_all_assignments_f
989: WHERE business_group_id = p_business_group_id;
990: hr_utility.set_location(l_proc, 260);

Line 988: DELETE FROM per_all_assignments_f

984: hr_utility.set_location(l_proc, 250);
985: --
986: -- WWBUG 1833930. Changed to use base table per_all_assignments_f
987: --
988: DELETE FROM per_all_assignments_f
989: WHERE business_group_id = p_business_group_id;
990: hr_utility.set_location(l_proc, 260);
991: --
992: end if;