DBA Data[Home] [Help]

APPS.PAY_JP_FORMULA_FUNCTION_PKG dependencies on FND_DATE

Line 53: 'D', to_char(fnd_date.canonical_to_date(pur.row_low_range_or_name)),

49: between pur.effective_start_date and pur.effective_end_date
50: and nvl(pur.business_group_id, p_business_group_id) = p_business_group_id
51: and nvl(pur.legislation_code, l_legislation_code) = l_legislation_code
52: and decode(put.user_key_units,
53: 'D', to_char(fnd_date.canonical_to_date(pur.row_low_range_or_name)),
54: 'N', pur.row_low_range_or_name,
55: 'T', pur.row_low_range_or_name,
56: null)
57: =

Line 59: 'D', to_char(fnd_date.canonical_to_date(p_row_value)),

55: 'T', pur.row_low_range_or_name,
56: null)
57: =
58: decode(put.user_key_units,
59: 'D', to_char(fnd_date.canonical_to_date(p_row_value)),
60: 'N', p_row_value,
61: 'T', p_row_value,
62: null)
63: and puc.user_table_id = put.user_table_id