APPS.GHR_BEN_VALIDATION dependencies on FND_SESSIONS

Line 621: l_session_date fnd_sessions.effective_date%type;

617: l_tsp_status varchar2(20);
618: l_tsp_status_date varchar2(20);
619: l_amount number;
620: l_business_group_id per_all_people_f.business_group_id%type;
621: l_session_date fnd_sessions.effective_date%type;
622:
623: l_health_plan varchar2(20);
624: l_enrollment_option varchar2(20);
625: l_temps_total_cost varchar2(20);

Line 779: CURSOR c_sess_date(c_session_id fnd_sessions.session_id%type)

775: FROM per_all_assignments_f asg
776: WHERE asg.person_id = c_person_id
777: AND c_effective_date BETWEEN asg.effective_start_date AND asg.effective_end_date;
778:
779: CURSOR c_sess_date(c_session_id fnd_sessions.session_id%type)
780: IS
781: SELECT effective_date
782: FROM fnd_sessions
783: WHERE session_id = c_session_id;

Line 782: FROM fnd_sessions

778:
779: CURSOR c_sess_date(c_session_id fnd_sessions.session_id%type)
780: IS
781: SELECT effective_date
782: FROM fnd_sessions
783: WHERE session_id = c_session_id;
784:
785: CURSOR c_per_ei(c_per_extra_info_id per_people_extra_info.person_extra_info_id%type,
786: c_information_type per_people_extra_info.information_type%type) IS

Line 792: l_effective_date fnd_sessions.effective_date%type;

788: FROM per_people_extra_info ppei
789: WHERE ppei.person_extra_info_id = c_per_extra_info_id
790: AND ppei.information_type = c_information_type;
791:
792: l_effective_date fnd_sessions.effective_date%type;
793: l_session_id fnd_sessions.session_id%type;
794: l_assignment_type per_all_assignments_f.assignment_type%type;
795: l_assignment_id per_all_assignments_f.assignment_id%type;
796: l_agency_contrib_date date;

Line 793: l_session_id fnd_sessions.session_id%type;

789: WHERE ppei.person_extra_info_id = c_per_extra_info_id
790: AND ppei.information_type = c_information_type;
791:
792: l_effective_date fnd_sessions.effective_date%type;
793: l_session_id fnd_sessions.session_id%type;
794: l_assignment_type per_all_assignments_f.assignment_type%type;
795: l_assignment_id per_all_assignments_f.assignment_id%type;
796: l_agency_contrib_date date;
797: l_emp_contrib_date date;