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 1578: FROM PER_BOOKINGS B

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

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

1584: AND E.DATE_START >= P_date_end
1585: AND E.EVENT_OR_INTERVIEW = 'I'
1586: AND E.ASSIGNMENT_ID = A.ASSIGNMENT_ID;
1587: --
1588: -- the person_id on per_bookings is the employee who is doing the
1589: -- interviewing of the applicant and is NOT the applicant.
1590: --
1591:
1592: CURSOR c_viewers IS

Line 1594: from PER_BOOKINGS B

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

Line 1628: DELETE FROM per_bookings bk

1624: OPEN c_viewers;
1625: FETCH c_viewers into r_interviewers;
1626: CLOSE c_viewers;
1627: FOR c_viewers_rec IN c_viewers LOOP
1628: DELETE FROM per_bookings bk
1629: WHERE bk.business_group_id + 0 = p_business_group_id
1630: AND bk.booking_id = c_viewers_rec.BOOKING_ID
1631: AND bk.person_id = c_viewers_rec.PERSON_ID;
1632: END LOOP;