DBA Data[Home] [Help]

APPS.PAY_JP_FORMULA_FUNCTION_PKG dependencies on FND_DATE

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

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

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

51: 'T', pur.row_low_range_or_name,
52: null)
53: =
54: decode(put.user_key_units,
55: 'D', to_char(fnd_date.canonical_to_date(p_row_value)),
56: 'N', p_row_value,
57: 'T', p_row_value,
58: null)
59: and puc.user_table_id = put.user_table_id