[Home] [Help]
81: --l_start_date date;-- default to_date ('2012-08-01', 'yyyy-mm-dd');
82: --l_end_date date;-- default to_date ('2012-08-31', 'yyyy-mm-dd');
83:
84: l_cur_element_entry_assignment cur_element_entry_assignment%ROWTYPE;
85: l_full_name per_all_people_f.full_name%TYPE;
86: l_age number;
87: l_auto_enrol_date/*auto_en_date*/ pay_element_entry_values_f.screen_entry_value%TYPE;
88: l_total_earning_prp pay_element_entry_values_f.screen_entry_value%TYPE;
89: l_opt_out_date pay_element_entry_values_f.screen_entry_value%TYPE;
156: (full_name)
157: , extract (year FROM sysdate) - extract (year FROM date_of_birth)
158: INTO l_full_name
159: , l_age
160: FROM per_all_people_f
161: WHERE person_id = l_person_assign_num.person_id
162: AND l_period.end_date between effective_start_date and effective_end_date;
163:
164: l_string := l_string || '
220: (full_name)
221: , extract (year FROM sysdate) - extract (year FROM date_of_birth)
222: INTO l_full_name
223: , l_age
224: FROM per_all_people_f
225: WHERE person_id = l_person_assign_num.person_id
226: AND l_period.end_date between effective_start_date and effective_end_date;
227:
228: l_string := l_string || '
281: (full_name)
282: , extract (year FROM sysdate) - extract (year FROM date_of_birth)
283: INTO l_full_name
284: , l_age
285: FROM per_all_people_f
286: WHERE person_id = l_person_assign_num.person_id
287: AND l_period.end_date between effective_start_date and effective_end_date;
288:
289:
378: (full_name)
379: , extract (year FROM sysdate) - extract (year FROM date_of_birth)
380: INTO l_full_name
381: , l_age
382: FROM per_all_people_f
383: WHERE person_id = l_person_assign_num.person_id
384: AND l_period.end_date between effective_start_date and effective_end_date;
385:
386: -- if ( l_input_id_value.pension_classification IN ('Non Eligible Job Holder')