APPS.PAY_JP_IWHT_ARCH_PKG dependencies on FND_DATE

Line 181: ,fnd_date.canonical_to_date(pay_core_utils.get_parameter('TERMINATION_DATE_FROM', legislative_parameters))

177: SELECT business_group_id
178: ,effective_date
179: ,fnd_number.canonical_to_number(pay_core_utils.get_parameter('ITAX_ORGANIZATION_ID',legislative_parameters))
180: ,fnd_number.canonical_to_number(pay_core_utils.get_parameter('PAYROLL_ID',legislative_parameters))
181: ,fnd_date.canonical_to_date(pay_core_utils.get_parameter('TERMINATION_DATE_FROM', legislative_parameters))
182: ,fnd_date.canonical_to_date(pay_core_utils.get_parameter('TERMINATION_DATE_TO',legislative_parameters))
183: ,fnd_number.canonical_to_number(pay_core_utils.get_parameter('ASSIGNMENT_SET_ID',legislative_parameters))
184: ,pay_core_utils.get_parameter('REARCHIVE_FLAG',legislative_parameters)
185: FROM pay_payroll_actions PPA

Line 182: ,fnd_date.canonical_to_date(pay_core_utils.get_parameter('TERMINATION_DATE_TO',legislative_parameters))

178: ,effective_date
179: ,fnd_number.canonical_to_number(pay_core_utils.get_parameter('ITAX_ORGANIZATION_ID',legislative_parameters))
180: ,fnd_number.canonical_to_number(pay_core_utils.get_parameter('PAYROLL_ID',legislative_parameters))
181: ,fnd_date.canonical_to_date(pay_core_utils.get_parameter('TERMINATION_DATE_FROM', legislative_parameters))
182: ,fnd_date.canonical_to_date(pay_core_utils.get_parameter('TERMINATION_DATE_TO',legislative_parameters))
183: ,fnd_number.canonical_to_number(pay_core_utils.get_parameter('ASSIGNMENT_SET_ID',legislative_parameters))
184: ,pay_core_utils.get_parameter('REARCHIVE_FLAG',legislative_parameters)
185: FROM pay_payroll_actions PPA
186: WHERE PPA.payroll_action_id = p_payroll_action_id;

Line 1399: ,p_action_information14 => fnd_date.date_to_canonical(lr_emp_rec.hire_date)

1395: ,p_action_information10 => lc_1st_jan_district_code
1396: ,p_action_information11 => lc_1st_jan_address_line1
1397: ,p_action_information12 => lc_1st_jan_address_line2
1398: ,p_action_information13 => lc_1st_jan_address_line3
1399: ,p_action_information14 => fnd_date.date_to_canonical(lr_emp_rec.hire_date)
1400: ,p_action_information15 => fnd_date.date_to_canonical(lr_emp_rec.termination_date)
1401: ,p_action_information16 => ln_service_years
1402: ,p_action_information17 => lr_emp_rec.withhold_agent_id
1403: ,p_action_information18 => lc_swot_employer

Line 1400: ,p_action_information15 => fnd_date.date_to_canonical(lr_emp_rec.termination_date)

1396: ,p_action_information11 => lc_1st_jan_address_line1
1397: ,p_action_information12 => lc_1st_jan_address_line2
1398: ,p_action_information13 => lc_1st_jan_address_line3
1399: ,p_action_information14 => fnd_date.date_to_canonical(lr_emp_rec.hire_date)
1400: ,p_action_information15 => fnd_date.date_to_canonical(lr_emp_rec.termination_date)
1401: ,p_action_information16 => ln_service_years
1402: ,p_action_information17 => lr_emp_rec.withhold_agent_id
1403: ,p_action_information18 => lc_swot_employer
1404: ,p_action_information19 => lc_swot_address_line1

Line 1447: ,p_action_information7 => fnd_date.date_to_canonical(ld_term_payment_date)

1443: ,p_action_information3 => fnd_number.number_to_canonical(ln_withholidng_tax)
1444: ,p_action_information4 => fnd_number.number_to_canonical(ln_muncipal_tax)
1445: ,p_action_information5 => fnd_number.number_to_canonical(ln_prefectural_tax)
1446: ,p_action_information6 => fnd_number.number_to_canonical(ln_term_ded_amt)
1447: ,p_action_information7 => fnd_date.date_to_canonical(ld_term_payment_date)
1448: ,p_action_information8 => fnd_date.date_to_canonical(ld_date_earned)
1449: ,p_action_information_id => ln_tax_action_info_id
1450: ,p_object_version_number => ln_tax_obj_version_num
1451: );

Line 1448: ,p_action_information8 => fnd_date.date_to_canonical(ld_date_earned)

1444: ,p_action_information4 => fnd_number.number_to_canonical(ln_muncipal_tax)
1445: ,p_action_information5 => fnd_number.number_to_canonical(ln_prefectural_tax)
1446: ,p_action_information6 => fnd_number.number_to_canonical(ln_term_ded_amt)
1447: ,p_action_information7 => fnd_date.date_to_canonical(ld_term_payment_date)
1448: ,p_action_information8 => fnd_date.date_to_canonical(ld_date_earned)
1449: ,p_action_information_id => ln_tax_action_info_id
1450: ,p_object_version_number => ln_tax_obj_version_num
1451: );
1452: --