APPS.PAY_IVL_DEL dependencies on PAY_INPUT_VALUES_F

Line 71: delete from pay_input_values_f

67: --
68: -- Delete the where the effective start date is equal
69: -- to the validation end date.
70: --
71: delete from pay_input_values_f
72: where input_value_id = p_rec.input_value_id
73: and effective_start_date = p_validation_start_date;
74: --
75: pay_ivl_shd.g_api_dml := false; -- Unset the api dml status

Line 82: delete from pay_input_values_f

78: --
79: -- Delete the row(s) where the effective start date is greater than
80: -- or equal to the validation start date.
81: --
82: delete from pay_input_values_f
83: where input_value_id = p_rec.input_value_id
84: and effective_start_date >= p_validation_start_date;
85: --
86: pay_ivl_shd.g_api_dml := false; -- Unset the api dml status

Line 412: (p_module_name => 'PAY_INPUT_VALUES_F'

408: --
409: when hr_api.cannot_find_prog_unit then
410: --
411: hr_api.cannot_find_prog_unit_error
412: (p_module_name => 'PAY_INPUT_VALUES_F'
413: ,p_hook_type => 'AD');
414: --
415: end;
416: --

Line 445: ,p_base_table_name => 'pay_input_values_f'

441:
442: dt_api.validate_dt_mode
443: (p_effective_date => p_effective_date
444: ,p_datetrack_mode => p_datetrack_mode
445: ,p_base_table_name => 'pay_input_values_f'
446: ,p_base_key_column => 'input_value_id'
447: ,p_base_key_value => p_rec.input_value_id
448: ,p_parent_table_name1 => 'pay_element_types_f'
449: ,p_parent_key_column1 => 'element_type_id'

Line 474: 'PAY_INPUT_VALUES_F');

470: p_effective_date,
471: l_validation_start_date,
472: l_validation_end_date,
473: p_datetrack_mode,
474: 'PAY_INPUT_VALUES_F');
475:
476:
477: --
478: -- delete DB items if zapping the input value