APPS.PQP_CAR_MILEAGE_FUNCTIONS dependencies on FND_DATE

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

1263: AND nvl (R.legislation_code,
1264: g_leg_code) = g_leg_code
1265: AND decode
1266: (TAB.user_key_units,
1267: 'D', to_char(fnd_date.canonical_to_date(p_row_value)),
1268: 'N',replace(replace( upper(p_row_value),'_',' '),' '),
1269: 'T', replace(replace(upper (p_row_value),'_',' '),' '),
1270: null) =
1271: decode

Line 1273: 'D', to_char(fnd_date.canonical_to_date(R.row_low_range_or_name)),

1269: 'T', replace(replace(upper (p_row_value),'_',' '),' '),
1270: null) =
1271: decode
1272: (TAB.user_key_units,
1273: 'D', to_char(fnd_date.canonical_to_date(R.row_low_range_or_name)),
1274: 'N', replace(replace(upper(R.row_low_range_or_name),'_',' '),' '),
1275: 'T', replace(replace(upper (R.row_low_range_or_name),'_',' '),' '),
1276: null)
1277: AND CINST.user_row_id = R.user_row_id

Line 1317: 'D', to_char(fnd_date.canonical_to_date(l_fuel_type.meaning)),

1313: AND nvl (R.legislation_code,
1314: g_leg_code) = g_leg_code
1315: AND decode
1316: (TAB.user_key_units,
1317: 'D', to_char(fnd_date.canonical_to_date(l_fuel_type.meaning)),
1318: 'T', replace(replace(upper (l_fuel_type.meaning),'_',' '),' '),
1319: null) =
1320: decode
1321: (TAB.user_key_units,

Line 1322: 'D', to_char(fnd_date.canonical_to_date(R.row_low_range_or_name)),

1318: 'T', replace(replace(upper (l_fuel_type.meaning),'_',' '),' '),
1319: null) =
1320: decode
1321: (TAB.user_key_units,
1322: 'D', to_char(fnd_date.canonical_to_date(R.row_low_range_or_name)),
1323: 'N', replace(replace(upper(R.row_low_range_or_name),'_',' '),' '),
1324: 'T', replace(replace(upper (R.row_low_range_or_name),'_',' '),' '),
1325: null)
1326: AND CINST.user_row_id = R.user_row_id

Line 2659: --AND FND_DATE.canonical_to_date(screen_entry_value) < cp_to_date

2655: AND pev.input_value_id =(SELECT input_value_id
2656: FROM pay_input_values_f
2657: WHERE element_type_id=petef.element_type_id
2658: AND name='Claim Start Date') and pee.assignment_id=cp_assignment_id
2659: --AND FND_DATE.canonical_to_date(screen_entry_value) < cp_to_date
2660: AND (screen_entry_value) > FND_DATE.date_to_canonical (cp_to_date)
2661: AND EXISTS (select 'Y'
2662: from pay_run_results RESULT,
2663: pay_assignment_actions ASGT_ACTION,

Line 2660: AND (screen_entry_value) > FND_DATE.date_to_canonical (cp_to_date)

2656: FROM pay_input_values_f
2657: WHERE element_type_id=petef.element_type_id
2658: AND name='Claim Start Date') and pee.assignment_id=cp_assignment_id
2659: --AND FND_DATE.canonical_to_date(screen_entry_value) < cp_to_date
2660: AND (screen_entry_value) > FND_DATE.date_to_canonical (cp_to_date)
2661: AND EXISTS (select 'Y'
2662: from pay_run_results RESULT,
2663: pay_assignment_actions ASGT_ACTION,
2664: pay_payroll_actions PAY_ACTION,