119: TYPE r_asg_details IS RECORD(
120: person_id NUMBER
121: ,effective_start_date DATE
122: ,effective_end_date DATE
123: ,assignment_number per_all_assignments_f.assignment_number%TYPE
124: ,primary_flag per_all_assignments_f.primary_flag%TYPE
125: ,normal_hours per_all_assignments_f.normal_hours%TYPE
126: ,assignment_status_type_id NUMBER
127: ,employment_category per_all_assignments_f.employment_category%TYPE
120: person_id NUMBER
121: ,effective_start_date DATE
122: ,effective_end_date DATE
123: ,assignment_number per_all_assignments_f.assignment_number%TYPE
124: ,primary_flag per_all_assignments_f.primary_flag%TYPE
125: ,normal_hours per_all_assignments_f.normal_hours%TYPE
126: ,assignment_status_type_id NUMBER
127: ,employment_category per_all_assignments_f.employment_category%TYPE
128: );
121: ,effective_start_date DATE
122: ,effective_end_date DATE
123: ,assignment_number per_all_assignments_f.assignment_number%TYPE
124: ,primary_flag per_all_assignments_f.primary_flag%TYPE
125: ,normal_hours per_all_assignments_f.normal_hours%TYPE
126: ,assignment_status_type_id NUMBER
127: ,employment_category per_all_assignments_f.employment_category%TYPE
128: );
129:
123: ,assignment_number per_all_assignments_f.assignment_number%TYPE
124: ,primary_flag per_all_assignments_f.primary_flag%TYPE
125: ,normal_hours per_all_assignments_f.normal_hours%TYPE
126: ,assignment_status_type_id NUMBER
127: ,employment_category per_all_assignments_f.employment_category%TYPE
128: );
129:
130: TYPE r_lookup_code IS RECORD(
131: lookup_code hr_lookups.lookup_code%TYPE
212: g_tab_pen_sch_map_cv pqp_utilities.t_config_values;
213: g_tab_pen_ele_ids t_element_details;
214: g_tab_prs_dfn_cv pqp_utilities.t_config_values;
215: g_person_dtl per_all_people_f%ROWTYPE;
216: g_assignment_dtl per_all_assignments_f%ROWTYPE;
217: g_tab_eei_info t_eei_info;
218: g_tab_clas_pen_bal_dtls t_pen_bal_dtls;
219: g_tab_clap_pen_bal_dtls t_pen_bal_dtls;
220: g_tab_prem_pen_bal_dtls t_pen_bal_dtls;