APPS.HR_MEE_VIEWS_GEN dependencies on FND_SESSIONS

Line 762: FROM per_pay_proposals ppp, fnd_sessions fs

758: FUNCTION getAsgProposalId(p_assignment_id IN NUMBER) RETURN NUMBER IS
759: l_proposal_id Number := -1;
760: CURSOR c_proposal IS
761: SELECT nvl(max(pay_proposal_id),-1)
762: FROM per_pay_proposals ppp, fnd_sessions fs
763: WHERE fs.session_id = userenv('sessionid')
764: AND ppp.assignment_id = p_assignment_id
765: AND ppp.approved = 'Y'
766: AND fs.effective_date between ppp.change_date and ppp.date_to;

Line 780: FROM per_applications, fnd_sessions fs

776: FUNCTION getPrsnApplicationId(p_person_id IN NUMBER) RETURN NUMBER IS
777: l_application_id Number := -1;
778: CURSOR c_applications IS
779: SELECT nvl(max(application_id),-1)
780: FROM per_applications, fnd_sessions fs
781: WHERE fs.session_id = userenv('sessionid')
782: AND person_id = p_person_id
783: AND fs.effective_date between date_received and nvl(date_end,fs.effective_date);
784:

Line 802: FROM per_performance_reviews ipr, fnd_sessions fs

798: SELECT nvl(max(performance_review_id),-1)
799: FROM per_performance_reviews pr
800: WHERE pr.person_id = p_person_id
801: AND pr.review_date = (SELECT max(review_date)
802: FROM per_performance_reviews ipr, fnd_sessions fs
803: WHERE fs.session_id = userenv('sessionid')
804: AND ipr.person_id = pr.person_id
805: AND ipr.review_date <= fs.effective_date);
806: