eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PAY_GB_ENROLL_PEN_REPORTING dependencies on FND_DATE

Line 149: (fnd_date.canonical_to_date(l_input_id_value.auto_enrollment_date) between l_period.start_date and l_period.end_date) THEN

145: close cur_input_id_value;
146:
147:
148: IF (l_input_id_value.qualifying_scheme_name IS NOT NULL) and
149: (fnd_date.canonical_to_date(l_input_id_value.auto_enrollment_date) between l_period.start_date and l_period.end_date) THEN
150:
151: open cur_person_assign_num(l_cur_element_entry_assignment.assignment_id,l_period.end_date);
152: fetch cur_person_assign_num into l_person_assign_num;
153: close cur_person_assign_num;

Line 168: l_string := l_string || ''||fnd_date.date_to_displaydate(fnd_date.canonical_to_date(l_input_id_value.auto_enrollment_date))||''||EOL;

164: l_string := l_string || ''||EOL;
165: l_string := l_string || ''||l_person_assign_num.assignment_number||''||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;

Line 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;

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:
175: dbms_lob.writeAppend( l_xml, length(l_string), l_string );

Line 234: --l_string := l_string || ''||fnd_date.date_to_displaydate(fnd_date.canonical_to_date(l_input_id_value.auto_enrollment_date))||''||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:
237: dbms_lob.writeAppend( l_xml, length(l_string), l_string );
238: l_string := null;

Line 291: (fnd_date.canonical_to_date(l_input_id_value.postponement_end_date) >=l_period.end_date) and

287: AND l_period.end_date between effective_start_date and effective_end_date;
288:
289:
290: if (
291: (fnd_date.canonical_to_date(l_input_id_value.postponement_end_date) >=l_period.end_date) and
292: l_input_id_value.auto_enrollment_date is null and
293: l_input_id_value.postponement_type ='ELIGIBLE JOB HOLDER DEFERMENT'
294: ) then
295: l_string := l_string || ''||EOL;

Line 299: l_string := l_string || ''||fnd_date.date_to_displaydate(fnd_date.canonical_to_date(l_input_id_value.first_found_elig_date))||''||EOL;

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:
303: dbms_lob.writeAppend( l_xml, length(l_string), l_string );

Line 300: l_string := l_string || ''||fnd_date.date_to_displaydate(fnd_date.canonical_to_date(l_input_id_value.post_period_end_date))||''||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:
303: dbms_lob.writeAppend( l_xml, length(l_string), l_string );
304: l_string := null;

Line 322: (fnd_date.canonical_to_date(l_input_id_value.postponement_end_date) >=l_period.end_date)

318: l_string := null;
319: end if;
320:
321: if (
322: (fnd_date.canonical_to_date(l_input_id_value.postponement_end_date) >=l_period.end_date)
323: --AND l_input_id_value.pension_classification IS NULL
324: AND l_input_id_value.auto_enrollment_date IS NULL
325: AND l_input_id_value.postponement_type ='WORKER DEFERMENT'
326: ) then

Line 330: l_string := l_string || ''||fnd_date.date_to_displaydate(fnd_date.canonical_to_date(l_input_id_value.post_period_end_date))||''||EOL;

326: ) then
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 );

Line 387: if ( fnd_date.canonical_to_date(l_input_id_value.opt_in_date)

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')
387: if ( fnd_date.canonical_to_date(l_input_id_value.opt_in_date)
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;

Line 393: l_string := l_string || ''||fnd_date.date_to_displaydate(fnd_date.canonical_to_date(l_input_id_value.opt_in_Date))||''||EOL;

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 );
397: l_string := null;