APPS.PER_APPLICATIONS_PKG dependencies on PER_EVENTS

Line 1565: FROM PER_EVENTS E

1561: P_Business_group_id NUMBER,
1562: P_application_id NUMBER) IS
1563: CURSOR chk_events IS
1564: SELECT E.EVENT_ID
1565: FROM PER_EVENTS E
1566: , PER_ASSIGNMENTS_F A
1567: WHERE A.PERSON_ID = P_person_id
1568: AND E.business_group_id + 0 = p_business_group_id
1569: AND A.business_group_id + 0 = p_business_group_id

Line 1579: , PER_EVENTS E

1575:
1576: CURSOR chk_bookings IS
1577: SELECT distinct(1)
1578: FROM PER_BOOKINGS B
1579: , PER_EVENTS E
1580: , PER_ASSIGNMENTS_F A
1581: WHERE A.PERSON_ID = P_person_id
1582: AND A.APPLICATION_ID = P_application_id
1583: AND B.EVENT_ID = E.EVENT_ID

Line 1595: , PER_EVENTS E

1591:
1592: CURSOR c_viewers IS
1593: select B.PERSON_ID,B.BOOKING_ID
1594: from PER_BOOKINGS B
1595: , PER_EVENTS E
1596: , PER_ASSIGNMENTS A
1597: where B.business_group_id + 0 = p_business_group_id
1598: and E.business_group_id + 0 = p_business_group_id
1599: and A.business_group_id + 0 = p_business_group_id

Line 1635: DELETE FROM per_events ev

1631: AND bk.person_id = c_viewers_rec.PERSON_ID;
1632: END LOOP;
1633:
1634: FOR chk_events_rec IN chk_events LOOP
1635: DELETE FROM per_events ev
1636: WHERE ev.event_id = chk_events_rec.event_id
1637: AND ev.business_group_id + 0 = p_business_group_id;
1638: END LOOP;
1639: --

Line 1642: DELETE FROM per_events ev

1638: END LOOP;
1639: --
1640: ELSE CLOSE chk_bookings;
1641: FOR chk_events_rec IN chk_events LOOP
1642: DELETE FROM per_events ev
1643: WHERE ev.event_id = chk_events_rec.event_id
1644: AND ev.business_group_id + 0 = p_business_group_id;
1645: END LOOP;
1646: