DBA Data[Home] [Help]

APPS.PQH_RMR_DEL dependencies on PQH_RATE_MATRIX_RATES_F

Line 71: delete from pqh_rate_matrix_rates_f

67: --
68: -- Delete the where the effective start date is equal
69: -- to the validation end date.
70: --
71: delete from pqh_rate_matrix_rates_f
72: where rate_matrix_rate_id = p_rec.rate_matrix_rate_id
73: and effective_start_date = p_validation_start_date;
74: --
75: --

Line 82: delete from pqh_rate_matrix_rates_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 pqh_rate_matrix_rates_f
83: where rate_matrix_rate_id = p_rec.rate_matrix_rate_id
84: and effective_start_date >= p_validation_start_date;
85: --
86: --

Line 391: (p_module_name => 'PQH_RATE_MATRIX_RATES_F'

387: --
388: when hr_api.cannot_find_prog_unit then
389: --
390: hr_api.cannot_find_prog_unit_error
391: (p_module_name => 'PQH_RATE_MATRIX_RATES_F'
392: ,p_hook_type => 'AD');
393: --
394: end;
395: --