APPS.PER_APPLICATIONS_PKG dependencies on PER_EVENTS

Line 1443: FROM PER_EVENTS E

1439: P_Business_group_id NUMBER,
1440: P_application_id NUMBER) IS
1441: CURSOR chk_events IS
1442: SELECT E.EVENT_ID
1443: FROM PER_EVENTS E
1444: , PER_ASSIGNMENTS_F A
1445: WHERE A.PERSON_ID = P_person_id
1446: AND E.business_group_id + 0 = p_business_group_id
1447: AND A.business_group_id + 0 = p_business_group_id

Line 1457: , PER_EVENTS E

1453:
1454: CURSOR chk_bookings IS
1455: SELECT distinct(1)
1456: FROM PER_BOOKINGS B
1457: , PER_EVENTS E
1458: , PER_ASSIGNMENTS_F A
1459: WHERE A.PERSON_ID = P_person_id
1460: AND A.APPLICATION_ID = P_application_id
1461: AND B.EVENT_ID = E.EVENT_ID

Line 1473: , PER_EVENTS E

1469:
1470: CURSOR c_viewers IS
1471: select B.PERSON_ID,B.BOOKING_ID
1472: from PER_BOOKINGS B
1473: , PER_EVENTS E
1474: , PER_ASSIGNMENTS A
1475: where B.business_group_id + 0 = p_business_group_id
1476: and E.business_group_id + 0 = p_business_group_id
1477: and A.business_group_id + 0 = p_business_group_id

Line 1513: DELETE FROM per_events ev

1509: AND bk.person_id = c_viewers_rec.PERSON_ID;
1510: END LOOP;
1511:
1512: FOR chk_events_rec IN chk_events LOOP
1513: DELETE FROM per_events ev
1514: WHERE ev.event_id = chk_events_rec.event_id
1515: AND ev.business_group_id + 0 = p_business_group_id;
1516: END LOOP;
1517: --

Line 1520: DELETE FROM per_events ev

1516: END LOOP;
1517: --
1518: ELSE CLOSE chk_bookings;
1519: FOR chk_events_rec IN chk_events LOOP
1520: DELETE FROM per_events ev
1521: WHERE ev.event_id = chk_events_rec.event_id
1522: AND ev.business_group_id + 0 = p_business_group_id;
1523: END LOOP;
1524: