APPS.GHR_BEN_VALIDATION dependencies on PER_ALL_PEOPLE_F

Line 62: l_business_group_id per_all_people_f.business_group_id%type;

58: p_element_name varchar2,
59: p_effective_date date) RETURN BOOLEAN
60: IS
61: l_new_element_name varchar2(250);
62: l_business_group_id per_all_people_f.business_group_id%type;
63: l_element_type_id pay_element_types_f.element_type_id%type;
64: l_exists BOOLEAN;
65:
66: CURSOR c_element_exist(c_assignment_id per_all_assignments_f.assignment_id%type,

Line 620: l_business_group_id per_all_people_f.business_group_id%type;

616: l_rate number;
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);

Line 629: l_person_id per_all_people_f.person_id%type;

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);
633: l_retirement_plan ghr_pa_requests.retirement_plan%type;

Line 803: l_business_group_id per_all_people_f.business_group_id%type;

799: l_fegli_elig_exp_date date;
800: l_date_temp_elig date;
801: l_date_fehb_elig date;
802: l_tsp_scd date;
803: l_business_group_id per_all_people_f.business_group_id%type;
804: l_asg_ei_data per_assignment_extra_info%rowtype;
805: l_annuitant_indicator per_assignment_extra_info.aei_information5%type;
806: l_session ghr_history_api.g_session_var_type;
807: l_noa_id number;