APPS.HR_MEE_VIEWS_GEN dependencies on FND_SESSIONS

Line 719: FROM per_pay_proposals ppp, fnd_sessions fs

715: FUNCTION getAsgProposalId(p_assignment_id IN NUMBER) RETURN NUMBER IS
716: l_proposal_id Number := -1;
717: CURSOR c_proposal IS
718: SELECT nvl(max(pay_proposal_id),-1)
719: FROM per_pay_proposals ppp, fnd_sessions fs
720: WHERE fs.session_id = userenv('sessionid')
721: AND ppp.assignment_id = p_assignment_id
722: AND ppp.approved = 'Y'
723: AND ppp.change_date <= fs.effective_date;

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 759: FROM per_performance_reviews ipr, fnd_sessions fs

755: SELECT nvl(max(performance_review_id),-1)
756: FROM per_performance_reviews pr
757: WHERE pr.person_id = p_person_id
758: AND pr.review_date = (SELECT max(review_date)
759: FROM per_performance_reviews ipr, fnd_sessions fs
760: WHERE fs.session_id = userenv('sessionid')
761: AND ipr.person_id = pr.person_id
762: AND ipr.review_date <= fs.effective_date);
763: