APPS.SSP_SSPRPSMP_XMLP_PKG dependencies on PER_ALL_PEOPLE_F
Line 41: from per_all_people_f p1
37: (p_session_date between ppf.effective_start_date and ppf.effective_end_date)
38: or
39: (p_session_date > ppf.effective_end_date
40: and ppf.effective_end_date = (select max(p1.effective_end_date) 41: from per_all_people_f p1 42: where p1.person_id = ppf.person_id)
43: )
44: or
45: (p_session_date < ppf.effective_start_date