[Home] [Help]
233: v.equivalent_cost,
234: nvl(to_date(v.pay_start, 'YYYYMM'), trunc(v.effective_start_date, 'MM')) pay_start,
235: nvl(to_date(v.pay_end, 'YYYYMM'), trunc(v.effective_end_date, 'MM')) pay_end
236: from (
237: select /*+ ORDERED USE_NL(PEL PEE PEEV PIV) INDEX (PEE PAY_ELEMENT_ENTRIES_F_N51) */
238: pee.element_entry_id,
239: pee.effective_start_date,
240: pee.effective_end_date,
241: substrb(min(decode(piv.display_sequence, 1, peev.screen_entry_value, NULL)), 1, 30) tranpo_type,
249: substrb(min(decode(piv.display_sequence, 9, peev.screen_entry_value, NULL)), 1, 6) pay_start,
250: substrb(min(decode(piv.display_sequence, 10, peev.screen_entry_value, NULL)), 1, 6) pay_end
251: from pay_element_types_f pet,
252: pay_element_links_f pel,
253: pay_element_entries_f pee,
254: pay_element_entry_values_f peev,
255: pay_input_values_f piv
256: where pet.element_name = c_car_element_name
257: and pet.legislation_code = 'JP'
320: nvl(add_months(to_date(v.pay_start, 'YYYYMM'), v.si_month), trunc(v.effective_start_date, 'MM')) si_start,
321: nvl(add_months(to_date(v.pay_end, 'YYYYMM'), v.si_month), trunc(v.effective_end_date, 'MM')) si_end,
322: v.si_month
323: from (
324: select /*+ ORDERED USE_NL(PEL PEE PEEV PIV) INDEX (PEE PAY_ELEMENT_ENTRIES_F_N51) */
325: pee.element_entry_id,
326: pee.effective_start_date,
327: pee.effective_end_date,
328: substrb(min(decode(piv.display_sequence, 1, peev.screen_entry_value, NULL)), 1, 30) tranpo_type,
333: substrb(min(decode(piv.display_sequence, 9, peev.screen_entry_value, NULL)), 1, 6) pay_end,
334: nvl(fnd_number.canonical_to_number(min(decode(piv.display_sequence, 10, peev.screen_entry_value, NULL))), 0) si_month
335: from pay_element_types_f pet,
336: pay_element_links_f pel,
337: pay_element_entries_f pee,
338: pay_element_entry_values_f peev,
339: pay_input_values_f piv
340: where pet.element_name = c_train_element_name
341: and pet.legislation_code = 'JP'