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_JP_WIC_PKG dependencies on FND_DATE

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

392: select nvl(sum(decode(piv.display_sequence, 1, to_number(peev.screen_entry_value))), 0) taxable_income,
393: nvl(sum(decode(piv.display_sequence, 2, to_number(peev.screen_entry_value))), 0) si_prem,
394: sum(decode(piv.display_sequence, 3, to_number(peev.screen_entry_value))) mutual_aid_prem,
395: nvl(sum(decode(piv.display_sequence, 4, to_number(peev.screen_entry_value))), 0) itax,
396: min(decode(piv.display_sequence, 5, fnd_date.canonical_to_date(peev.screen_entry_value))) termination_date,
397: nvl(min(decode(piv.display_sequence, 6, peev.screen_entry_value)), 'N') foreign_address_flag,
398: min(decode(piv.display_sequence, 7, peev.screen_entry_value)) salary_payer_address_kana,
399: min(decode(piv.display_sequence, 8, peev.screen_entry_value)) salary_payer_address_kanji,
400: min(decode(piv.display_sequence, 9, peev.screen_entry_value)) salary_payer_name_kana,

Line 973: decode(piv_1.uom,'D',fnd_date.canonical_to_date(peev_1.screen_entry_value),null) residence_date,

969: INDEX(PEE PAY_ELEMENT_ENTRIES_F_N51)
970: INDEX(PEEV_1 PAY_ELEMENT_ENTRY_VALUES_F_N50)
971: INDEX(PEEV_2 PAY_ELEMENT_ENTRY_VALUES_F_N50)
972: INDEX(PEEV_3 PAY_ELEMENT_ENTRY_VALUES_F_N50) */
973: decode(piv_1.uom,'D',fnd_date.canonical_to_date(peev_1.screen_entry_value),null) residence_date,
974: peev_2.screen_entry_value loan_type,
975: decode(piv_3.uom,'M',fnd_number.canonical_to_number(peev_3.screen_entry_value),null) loan_balance
976: from pay_input_values_f piv_1,
977: pay_input_values_f piv_3,

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

3896: wic.itax_organization_id,
3897: wic.itax_category,
3898: wic.itax_yea_category,
3899: nvl(nvl(pay.prl_information1, hoi.org_information2), 'CTR_EE') DPNT_REF_TYPE,
3900: nvl(fnd_date.canonical_to_date(pay_core_utils.get_parameter('ITAX_DPNT_EFFECTIVE_DATE', wic.legislative_parameters)),
3901: wic.effective_date) DPNT_EFFECTIVE_DATE,
3902: per.person_id,
3903: per.sex,
3904: per.date_of_birth,