APPS.HR_DELETE dependencies on DUAL

Line 688: FROM sys.dual

684: cursor csr_get_asg
685: (c_business_group_id per_assignments_f.business_group_id%TYPE)
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: --

Line 697: FROM sys.dual

693: cursor csr_get_ast
694: (c_business_group_id per_assignments_f.business_group_id%TYPE)
695: is
696: SELECT null
697: FROM sys.dual
698: WHERE exists(select null
699: FROM per_assignment_status_types
700: WHERE business_group_id = c_business_group_id);
701: --

Line 706: FROM sys.dual

702: cursor csr_get_ltp
703: (c_business_group_id per_letter_types.business_group_id%TYPE)
704: is
705: SELECT null
706: FROM sys.dual
707: WHERE exists(select null
708: FROM per_letter_types
709: WHERE business_group_id = c_business_group_id);
710: --

Line 715: FROM sys.dual

711: cursor csr_get_prs
712: (c_business_group_id per_parent_spines.business_group_id%TYPE)
713: is
714: SELECT null
715: FROM sys.dual
716: WHERE exists(select null
717: FROM per_parent_spines
718: WHERE business_group_id = c_business_group_id);
719: --

Line 724: FROM sys.dual

720: cursor csr_get_gra
721: (c_business_group_id per_grades.business_group_id%TYPE)
722: is
723: SELECT null
724: FROM sys.dual
725: WHERE exists(select null
726: FROM per_grades
727: WHERE business_group_id = c_business_group_id);
728: --

Line 733: FROM sys.dual

729: cursor csr_get_job
730: (c_business_group_id per_jobs.business_group_id%TYPE)
731: is
732: SELECT null
733: FROM sys.dual
734: WHERE exists(select null
735: FROM per_jobs
736: WHERE business_group_id = c_business_group_id);
737: --

Line 743: FROM sys.dual

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
745: FROM PER_RECRUITMENT_ACTIVITIES
746: WHERE business_group_id = c_business_group_id);
747: --

Line 753: FROM sys.dual

749: (c_business_group_id
750: PER_REQUISITIONS.business_group_id%TYPE)
751: is
752: SELECT null
753: FROM sys.dual
754: WHERE exists(select null
755: FROM PER_REQUISITIONS
756: WHERE business_group_id = c_business_group_id);
757: --

Line 763: FROM sys.dual

759: (c_business_group_id
760: PER_BUDGETS.business_group_id%TYPE)
761: is
762: SELECT null
763: FROM sys.dual
764: WHERE exists(select null
765: FROM PER_BUDGETS
766: WHERE business_group_id = c_business_group_id);
767: --

Line 773: FROM sys.dual

769: (c_business_group_id
770: PER_PAY_PROPOSALS.business_group_id%TYPE)
771: is
772: SELECT null
773: FROM sys.dual
774: WHERE exists(select null
775: FROM PER_PAY_PROPOSALS
776: WHERE business_group_id = c_business_group_id);
777: --

Line 783: FROM sys.dual

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
785: FROM PER_CAREER_PATHS
786: WHERE business_group_id = c_business_group_id);
787: --

Line 793: FROM sys.dual

789: (c_business_group_id
790: PER_POSITION_STRUCTURES.business_group_id%TYPE)
791: is
792: SELECT null
793: FROM sys.dual
794: WHERE exists(select null
795: FROM PER_POSITION_STRUCTURES
796: WHERE business_group_id = c_business_group_id);
797: --

Line 803: FROM sys.dual

799: (c_business_group_id
800: per_events.business_group_id%TYPE)
801: is
802: SELECT null
803: FROM sys.dual
804: WHERE exists(select null
805: FROM per_events
806: WHERE business_group_id = c_business_group_id);
807: --