APPS.GHR_BEN_VALIDATION dependencies on PER_PEOPLE_EXTRA_INFO

Line 628: l_per_benefit_info per_people_extra_info%rowtype;

624: l_enrollment_option varchar2(20);
625: l_temps_total_cost varchar2(20);
626: l_pre_tax_waiver varchar2(20);
627: l_premium_rate varchar2(20);
628: l_per_benefit_info per_people_extra_info%rowtype;
629: l_person_id per_all_people_f.person_id%type;
630: l_new_element_name pay_element_types_f.element_name%type;
631: l_element_name pay_element_types_f.element_name%type;
632: l_ret_plan_name varchar2(200);

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

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
787: SELECT *
788: FROM per_people_extra_info ppei
789: WHERE ppei.person_extra_info_id = c_per_extra_info_id

Line 786: c_information_type per_people_extra_info.information_type%type) IS

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

Line 788: FROM per_people_extra_info ppei

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