DBA Data[Home] [Help]

APPS.PAY_MX_FF_UDFS dependencies on FND_DATE

Line 978: select nvl(FND_DATE.CANONICAL_TO_DATE(pev.SCREEN_ENTRY_VALUE),hr_general.end_of_time)

974:
975: CURSOR c_get_var_expiration_date (cp_asg_id pay_element_entries_f.assignment_id%TYPE,
976: cp_eff_date DATE)
977: IS
978: select nvl(FND_DATE.CANONICAL_TO_DATE(pev.SCREEN_ENTRY_VALUE),hr_general.end_of_time)
979: from pay_element_types_f pet,
980: pay_input_values_f piv,
981: pay_element_entries_f pee,
982: pay_element_entry_values_f pev

Line 1618: ld_eff_date := fnd_date.canonical_to_date('1900/01/01 00:00:00');

1614:
1615: BEGIN
1616: --{
1617:
1618: ld_eff_date := fnd_date.canonical_to_date('1900/01/01 00:00:00');
1619:
1620: lt_col_det_tab(1).col_name := 'Monthly Payroll Divisor';
1621: lt_col_det_tab(1).value := 12;
1622: lt_col_det_tab(2).col_name := 'Weekly Payroll Divisor';