APPS.HR_LEGISLATION_BENEFITS dependencies on HR_S_BENEFIT_CLASSIFICATIONS

Line 603: from hr_s_benefit_classifications;

599: , last_updated_by
600: , last_update_login
601: , created_by
602: , creation_date
603: from hr_s_benefit_classifications;
604:
605: stu_rec stu%ROWTYPE;
606:
607:

Line 644: from hr_s_benefit_classifications b

640: into l_null_return
641: from ben_benefit_classifications a
642: where exists
643: (select null
644: from hr_s_benefit_classifications b
645: where a.benefit_classification_id=b.benefit_classification_id
646: );
647:
648: --conflict may exist

Line 651: update hr_s_benefit_classifications

647:
648: --conflict may exist
649: --update all benefit_classification_id's to remove conflict
650:
651: update hr_s_benefit_classifications
652: set benefit_classification_id=benefit_classification_id-50000000;
653:
654: update hr_s_application_ownerships
655: set key_value = key_value - 50000000

Line 668: from hr_s_benefit_classifications;

664: select min(benefit_classification_id) - (count(*) *3)
665: , max(benefit_classification_id) + (count(*) *3)
666: into v_min_delivered
667: , v_max_delivered
668: from hr_s_benefit_classifications;
669:
670: select ben_benefit_classifications_s.nextval
671: into v_sequence_number
672: from dual;

Line 741: update hr_s_benefit_classifications

737:
738: -- Update all child entities
739:
740:
741: update hr_s_benefit_classifications
742: set benefit_classification_id = l_new_surrogate_key
743: where benefit_classification_id = stu_rec.c_surrogate_key;
744:
745:

Line 766: delete from hr_s_benefit_classifications

762:
763: BEGIN
764:
765:
766: delete from hr_s_benefit_classifications
767: where rowid = stu_rec.rowid;
768:
769: END remove;
770: