[Home] [Help]
91: p_element_name varchar2,
92: p_effective_date date) RETURN BOOLEAN
93: IS
94: l_new_element_name varchar2(250);
95: l_business_group_id per_all_people_f.business_group_id%type;
96: l_element_type_id pay_element_types_f.element_type_id%type;
97: l_exists BOOLEAN;
98:
99: CURSOR c_element_exist(c_assignment_id per_all_assignments_f.assignment_id%type,
821: l_rate number;
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);
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);
838: l_retirement_plan ghr_pa_requests.retirement_plan%type;
1226: l_fegli_elig_exp_date date;
1227: l_date_temp_elig date;
1228: l_date_fehb_elig date;
1229: l_tsp_scd date;
1230: l_business_group_id per_all_people_f.business_group_id%type;
1231: l_asg_ei_data per_assignment_extra_info%rowtype;
1232: l_annuitant_indicator per_assignment_extra_info.aei_information5%type;
1233: l_session ghr_history_api.g_session_var_type;
1234: l_noa_id number;