APPS.GHR_BEN_VALIDATION dependencies on PER_PEOPLE_EXTRA_INFO

Line 833: l_per_benefit_info per_people_extra_info%rowtype;

829: l_enrollment_option varchar2(20);
830: l_temps_total_cost varchar2(20);
831: l_pre_tax_waiver varchar2(20);
832: l_premium_rate varchar2(20);
833: l_per_benefit_info per_people_extra_info%rowtype;
834: l_person_id per_all_people_f.person_id%type;
835: l_new_element_name pay_element_types_f.element_name%type;
836: l_element_name pay_element_types_f.element_name%type;
837: l_ret_plan_name varchar2(200);

Line 1212: CURSOR c_per_ei(c_per_extra_info_id per_people_extra_info.person_extra_info_id%type,

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
1214: SELECT *
1215: FROM per_people_extra_info ppei
1216: WHERE ppei.person_extra_info_id = c_per_extra_info_id

Line 1213: c_information_type per_people_extra_info.information_type%type) IS

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
1214: SELECT *
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;

Line 1215: FROM per_people_extra_info ppei

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
1214: SELECT *
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;