APPS.HR_EX_EMPLOYEE_API dependencies on PER_EVENTS

Line 51: from per_events pe

47: select 'X'
48: into v_dummy
49: from sys.dual
50: where exists ( select 'Events exist'
51: from per_events pe
52: , per_bookings pb
53: where pe.business_group_id = pb.business_group_id
54: and (pb.business_group_id = p_business_group_id OR
55: nvl(fnd_profile.value('HR_CROSS_BUSINESS_GROUP'),'N')='Y')

Line 75: from per_events pe

71: select 'X'
72: into v_dummy
73: from sys.dual
74: where exists(select 'Interview rows exist'
75: from per_events pe
76: where pe.business_group_id + 0 = p_business_group_id
77: and pe.event_or_interview = 'I'
78: and pe.internal_contact_person_id = p_person_id
79: and pe.date_start > p_session_date

Line 83: from per_events pe

79: and pe.date_start > p_session_date
80: )
81: OR
82: exists(select 'Interview rows exist'
83: from per_events pe
84: ,per_bookings pb
85: where pe.business_group_id = pb.business_group_id
86: and (pb.business_group_id = p_business_group_id OR
87: nvl(fnd_profile.value('HR_CROSS_BUSINESS_GROUP'),'N')='Y')