DBA Data[Home] [Help]

APPS.PAY_JP_WIC_PKG dependencies on FND_DATE

Line 351: min(decode(piv.display_sequence, 5, fnd_date.canonical_to_date(peev.screen_entry_value))) termination_date,

347: select nvl(sum(decode(piv.display_sequence, 1, to_number(peev.screen_entry_value))), 0) taxable_income,
348: nvl(sum(decode(piv.display_sequence, 2, to_number(peev.screen_entry_value))), 0) si_prem,
349: sum(decode(piv.display_sequence, 3, to_number(peev.screen_entry_value))) mutual_aid_prem,
350: nvl(sum(decode(piv.display_sequence, 4, to_number(peev.screen_entry_value))), 0) itax,
351: min(decode(piv.display_sequence, 5, fnd_date.canonical_to_date(peev.screen_entry_value))) termination_date,
352: nvl(min(decode(piv.display_sequence, 6, peev.screen_entry_value)), 'N') foreign_address_flag,
353: min(decode(piv.display_sequence, 7, peev.screen_entry_value)) salary_payer_address_kana,
354: min(decode(piv.display_sequence, 8, peev.screen_entry_value)) salary_payer_address_kanji,
355: min(decode(piv.display_sequence, 9, peev.screen_entry_value)) salary_payer_name_kana,

Line 2409: nvl(fnd_date.canonical_to_date(pay_core_utils.get_parameter('ITAX_DPNT_EFFECTIVE_DATE', wic.legislative_parameters)),

2405: wic.itax_organization_id,
2406: wic.itax_category,
2407: wic.itax_yea_category,
2408: nvl(nvl(pay.prl_information1, hoi.org_information2), 'CTR_EE') DPNT_REF_TYPE,
2409: nvl(fnd_date.canonical_to_date(pay_core_utils.get_parameter('ITAX_DPNT_EFFECTIVE_DATE', wic.legislative_parameters)),
2410: wic.effective_date) DPNT_EFFECTIVE_DATE,
2411: per.person_id,
2412: per.sex,
2413: per.date_of_birth,