APPS.GHR_BEN_VALIDATION dependencies on FND_SESSIONS

Line 826: l_session_date fnd_sessions.effective_date%type;

822: l_tsp_status varchar2(20);
823: l_tsp_status_date varchar2(20);
824: l_amount number;
825: l_business_group_id per_all_people_f.business_group_id%type;
826: l_session_date fnd_sessions.effective_date%type;
827:
828: l_health_plan varchar2(20);
829: l_enrollment_option varchar2(20);
830: l_temps_total_cost varchar2(20);

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

1202: FROM per_all_assignments_f asg
1203: WHERE asg.person_id = c_person_id
1204: AND c_effective_date BETWEEN asg.effective_start_date AND asg.effective_end_date;
1205:
1206: CURSOR c_sess_date(c_session_id fnd_sessions.session_id%type)
1207: IS
1208: SELECT effective_date
1209: FROM fnd_sessions
1210: WHERE session_id = c_session_id;

Line 1209: FROM fnd_sessions

1205:
1206: CURSOR c_sess_date(c_session_id fnd_sessions.session_id%type)
1207: IS
1208: SELECT effective_date
1209: FROM fnd_sessions
1210: WHERE session_id = c_session_id;
1211:
1212: CURSOR c_per_ei(c_per_extra_info_id per_people_extra_info.person_extra_info_id%type,
1213: c_information_type per_people_extra_info.information_type%type) IS

Line 1219: l_effective_date fnd_sessions.effective_date%type;

1215: FROM per_people_extra_info ppei
1216: WHERE ppei.person_extra_info_id = c_per_extra_info_id
1217: AND ppei.information_type = c_information_type;
1218:
1219: l_effective_date fnd_sessions.effective_date%type;
1220: l_session_id fnd_sessions.session_id%type;
1221: l_assignment_type per_all_assignments_f.assignment_type%type;
1222: l_assignment_id per_all_assignments_f.assignment_id%type;
1223: l_agency_contrib_date date;

Line 1220: l_session_id fnd_sessions.session_id%type;

1216: WHERE ppei.person_extra_info_id = c_per_extra_info_id
1217: AND ppei.information_type = c_information_type;
1218:
1219: l_effective_date fnd_sessions.effective_date%type;
1220: l_session_id fnd_sessions.session_id%type;
1221: l_assignment_type per_all_assignments_f.assignment_type%type;
1222: l_assignment_id per_all_assignments_f.assignment_id%type;
1223: l_agency_contrib_date date;
1224: l_emp_contrib_date date;