APPS.HR_CONTINGENT_WORKER_API dependencies on PER_EVENTS

Line 1944: from per_events pe

1940: select 'X'
1941: into v_dummy
1942: from sys.dual
1943: where exists ( select 'Events exist'
1944: from per_events pe
1945: , per_bookings pb
1946: where pe.business_group_id = pb.business_group_id
1947: and (pb.business_group_id = p_business_group_id OR
1948: nvl(fnd_profile.value('HR_CROSS_BUSINESS_GROUP'),'N')='Y')

Line 1968: from per_events pe

1964: select 'X'
1965: into v_dummy
1966: from sys.dual
1967: where exists(select 'Interview rows exist'
1968: from per_events pe
1969: where pe.business_group_id = p_business_group_id
1970: and pe.event_or_interview = 'I'
1971: and pe.internal_contact_person_id = p_person_id
1972: and pe.date_start > p_session_date

Line 1976: from per_events pe

1972: and pe.date_start > p_session_date
1973: )
1974: OR
1975: exists(select 'Interview rows exist'
1976: from per_events pe
1977: ,per_bookings pb
1978: where pe.business_group_id = pb.business_group_id
1979: and (pb.business_group_id = p_business_group_id OR
1980: nvl(fnd_profile.value('HR_CROSS_BUSINESS_GROUP'),'N')='Y')