eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PER_APPLICATIONS_PKG dependencies on PER_BOOKINGS

Line 1456: FROM PER_BOOKINGS B

1452:
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

Line 1466: -- the person_id on per_bookings is the employee who is doing the

1462: AND E.DATE_START >= P_date_end
1463: AND E.EVENT_OR_INTERVIEW = 'I'
1464: AND E.ASSIGNMENT_ID = A.ASSIGNMENT_ID;
1465: --
1466: -- the person_id on per_bookings is the employee who is doing the
1467: -- interviewing of the applicant and is NOT the applicant.
1468: --
1469:
1470: CURSOR c_viewers IS

Line 1472: from PER_BOOKINGS B

1468: --
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

Line 1506: DELETE FROM per_bookings bk

1502: OPEN c_viewers;
1503: FETCH c_viewers into r_interviewers;
1504: CLOSE c_viewers;
1505: FOR c_viewers_rec IN c_viewers LOOP
1506: DELETE FROM per_bookings bk
1507: WHERE bk.business_group_id + 0 = p_business_group_id
1508: AND bk.booking_id = c_viewers_rec.BOOKING_ID
1509: AND bk.person_id = c_viewers_rec.PERSON_ID;
1510: END LOOP;