APPS.HR_MEE_VIEWS_GEN dependencies on PER_APPLICATIONS

Line 737: FROM per_applications, fnd_sessions fs

733: FUNCTION getPrsnApplicationId(p_person_id IN NUMBER) RETURN NUMBER IS
734: l_application_id Number := -1;
735: CURSOR c_applications IS
736: SELECT nvl(max(application_id),-1)
737: FROM per_applications, fnd_sessions fs
738: WHERE fs.session_id = userenv('sessionid')
739: AND person_id = p_person_id
740: AND fs.effective_date between date_received and nvl(date_end,fs.effective_date);
741:

Line 1061: FROM per_applications pa,

1057:
1058: CURSOR lc_get_lad (p_person_id IN per_people_f.person_id%TYPE)
1059: IS
1060: SELECT MAX(pa.date_received)
1061: FROM per_applications pa,
1062: per_assignments_f ass
1063: WHERE ass.application_id = pa.application_id
1064: AND ass.assignment_type = 'A'
1065: AND ass.person_id = p_person_id;