[Home] [Help]
134: statement for PAY_RATES to avoid
135: the referential integrity error
136: when RATE_ID is set for a pay basis.
137: c Moved the delete statement for
138: PER_EVENTS to after the delete
139: statement for PER_PAY_PROPOSALS to
140: avoid the referential integrity error
141: when EVENT_ID is set for a pay proposal.
142: 70.36 31-JUL-96 Tmathers a Made delete statment a dynamic sql
796: WHERE business_group_id = c_business_group_id);
797: --
798: cursor csr_get_evt
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
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: --
808: -- End of fix for WWBUG 1833930.
809: -- Changed all following cursors to use exists and for assignments
867: DELETE FROM per_bookings pb
868: WHERE pb.business_group_id = p_business_group_id;
869: hr_utility.set_location(l_proc,100);
870: --
871: DELETE FROM per_events
872: WHERE business_group_id = p_business_group_id;
873: hr_utility.set_location(l_proc,110);
874: --
875: end if;