APPS.HR_CONTINGENT_WORKER_API dependencies on PER_EVENTS

Line 1571: from per_events pe

1567: select 'X'
1568: into v_dummy
1569: from sys.dual
1570: where exists ( select 'Events exist'
1571: from per_events pe
1572: , per_bookings pb
1573: where pe.business_group_id = pb.business_group_id
1574: and (pb.business_group_id = p_business_group_id OR
1575: nvl(fnd_profile.value('HR_CROSS_BUSINESS_GROUP'),'N')='Y')

Line 1595: from per_events pe

1591: select 'X'
1592: into v_dummy
1593: from sys.dual
1594: where exists(select 'Interview rows exist'
1595: from per_events pe
1596: where pe.business_group_id = p_business_group_id
1597: and pe.event_or_interview = 'I'
1598: and pe.internal_contact_person_id = p_person_id
1599: and pe.date_start > p_session_date

Line 1603: from per_events pe

1599: and pe.date_start > p_session_date
1600: )
1601: OR
1602: exists(select 'Interview rows exist'
1603: from per_events pe
1604: ,per_bookings pb
1605: where pe.business_group_id = pb.business_group_id
1606: and (pb.business_group_id = p_business_group_id OR
1607: nvl(fnd_profile.value('HR_CROSS_BUSINESS_GROUP'),'N')='Y')