DBA Data[Home] [Help]

APPS.PAY_GB_ENROLL_PEN_REPORTING dependencies on HR_GENERAL

Line 170: l_string := l_string || ''||NVL(hr_general.decode_lookup('GB_PENSION_WORKER_TYPES',l_input_id_value.pension_classification),'N/A')||''||EOL;

166: l_string := l_string || ''||l_full_name||''||EOL;
167: l_string := l_string || ''||l_age||''||EOL;
168: l_string := l_string || ''||fnd_date.date_to_displaydate(fnd_date.canonical_to_date(l_input_id_value.auto_enrollment_date))||''||EOL;
169: l_string := l_string || ''||l_input_id_value.total_earning_PRP||''||EOL;/*total_earning_prp*/
170: l_string := l_string || ''||NVL(hr_general.decode_lookup('GB_PENSION_WORKER_TYPES',l_input_id_value.pension_classification),'N/A')||''||EOL;
171: l_string := l_string || ''||fnd_date.date_to_displaydate(fnd_date.canonical_to_date(l_input_id_value.opt_out_period_end_date))||''||EOL;
172: l_string := l_string || ''||l_input_id_value.qualifying_scheme_name||''||EOL;
173: l_string := l_string || ''||EOL;
174:

Line 232: l_string := l_string || ''||NVL(hr_general.decode_lookup('GB_PENSION_WORKER_TYPES',l_input_id_value.pension_classification),'N/A')||''||EOL;

228: l_string := l_string || ''||EOL;
229: l_string := l_string || ''||l_person_assign_num.assignment_number||''||EOL;
230: l_string := l_string || ''||l_full_name||''||EOL;
231: l_string := l_string || ''||l_age||''||EOL;
232: l_string := l_string || ''||NVL(hr_general.decode_lookup('GB_PENSION_WORKER_TYPES',l_input_id_value.pension_classification),'N/A')||''||EOL;
233: l_string := l_string || ''||l_input_id_value.qualifying_scheme_name||''||EOL;
234: --l_string := l_string || ''||fnd_date.date_to_displaydate(fnd_date.canonical_to_date(l_input_id_value.auto_enrollment_date))||''||EOL;
235: l_string := l_string || '
'||EOL;
236:

Line 298: l_string := l_string || ''||NVL(hr_general.decode_lookup('GB_PENSION_WORKER_TYPES',l_input_id_value.pension_classification),'N/A')||''||EOL;

294: ) then
295: l_string := l_string || ''||EOL;
296: l_string := l_string || ''||l_person_assign_num.assignment_number||''||EOL;
297: l_string := l_string || ''||l_full_name||''||EOL;
298: l_string := l_string || ''||NVL(hr_general.decode_lookup('GB_PENSION_WORKER_TYPES',l_input_id_value.pension_classification),'N/A')||''||EOL;
299: l_string := l_string || ''||fnd_date.date_to_displaydate(fnd_date.canonical_to_date(l_input_id_value.first_found_elig_date))||''||EOL;
300: l_string := l_string || ''||fnd_date.date_to_displaydate(fnd_date.canonical_to_date(l_input_id_value.post_period_end_date))||''||EOL;
301: l_string := l_string || '
'||EOL;
302:

Line 314: l_string := l_string || ''||NVL(hr_general.decode_lookup('GB_PENSION_WORKER_TYPES',l_input_id_value.pension_classification),'N/A')||''||EOL;

310: l_string := l_string || ''||l_person_assign_num.assignment_number||''||EOL;
311: l_string := l_string || ''||l_full_name||''||EOL;
312: l_string := l_string || ''||l_age||''||EOL;
313: l_string := l_string || ''||NVL(l_input_id_value.total_earning_PRP,'N/A')||''||EOL;
314: l_string := l_string || ''||NVL(hr_general.decode_lookup('GB_PENSION_WORKER_TYPES',l_input_id_value.pension_classification),'N/A')||''||EOL;
315: l_string := l_string || ''||EOL;
316:
317: dbms_lob.writeAppend( l_xml, length(l_string), l_string );
318: l_string := null;

Line 331: l_string := l_string || ''||NVL(hr_general.decode_lookup('GB_PENSION_WORKER_TYPES',l_input_id_value.pension_classification),'N/A')||''||EOL;

327: l_string := l_string || ''||EOL;
328: l_string := l_string || ''||l_person_assign_num.assignment_number||''||EOL;
329: l_string := l_string || ''||l_full_name||''||EOL;
330: l_string := l_string || ''||fnd_date.date_to_displaydate(fnd_date.canonical_to_date(l_input_id_value.post_period_end_date))||''||EOL;
331: l_string := l_string || ''||NVL(hr_general.decode_lookup('GB_PENSION_WORKER_TYPES',l_input_id_value.pension_classification),'N/A')||''||EOL;
332: l_string := l_string || '
'||EOL;
333:
334: dbms_lob.writeAppend( l_xml, length(l_string), l_string );
335: l_string := null;

Line 392: l_string := l_string || ''||NVL(hr_general.decode_lookup('GB_PENSION_WORKER_TYPES',l_input_id_value.pension_classification),'N/A')||''||EOL;

388: BETWEEN l_period.start_date AND l_period.end_date) then
389: l_string := l_string || ''||EOL;
390: l_string := l_string || ''||l_person_assign_num.assignment_number||''||EOL;
391: l_string := l_string || ''||l_full_name||''||EOL;
392: l_string := l_string || ''||NVL(hr_general.decode_lookup('GB_PENSION_WORKER_TYPES',l_input_id_value.pension_classification),'N/A')||''||EOL;
393: l_string := l_string || ''||fnd_date.date_to_displaydate(fnd_date.canonical_to_date(l_input_id_value.opt_in_Date))||''||EOL;
394: l_string := l_string || '
'||EOL;
395:
396: dbms_lob.writeAppend( l_xml, length(l_string), l_string );