APPS.PAY_GRR_SHD dependencies on PAY_GRADE_RULES_F

Line 85: from pay_grade_rules_f

81: program_id,
82: program_update_date,
83: object_version_number,
84: currency_code
85: from pay_grade_rules_f
86: where grade_rule_id = p_grade_rule_id
87: and p_effective_date
88: between effective_start_date and effective_end_date;
89: --

Line 165: p_base_table_name => 'pay_grade_rules_f',

161: -- Call the corresponding datetrack api
162: --
163: dt_api.find_dt_del_modes
164: (p_effective_date => p_effective_date,
165: p_base_table_name => 'pay_grade_rules_f',
166: p_base_key_column => 'grade_rule_id',
167: p_base_key_value => p_base_key_value,
168: p_zap => p_zap,
169: p_delete => p_delete,

Line 196: p_base_table_name => 'pay_grade_rules_f',

192: -- Call the corresponding datetrack api
193: --
194: dt_api.find_dt_upd_modes
195: (p_effective_date => p_effective_date,
196: p_base_table_name => 'pay_grade_rules_f',
197: p_base_key_column => 'grade_rule_id',
198: p_base_key_value => p_base_key_value,
199: p_correction => p_correction,
200: p_update => p_update,

Line 229: (p_base_table_name => 'pay_grade_rules_f',

225: -- version number.
226: --
227: l_object_version_number :=
228: dt_api.get_object_version_number
229: (p_base_table_name => 'pay_grade_rules_f',
230: p_base_key_column => 'grade_rule_id',
231: p_base_key_value => p_base_key_value);
232: --
233: hr_utility.set_location(l_proc, 10);

Line 239: update pay_grade_rules_f t

235: --
236: -- Update the specified datetrack row setting the effective
237: -- end date to the specified new effective end date.
238: --
239: update pay_grade_rules_f t
240: set t.effective_end_date = p_new_effective_end_date,
241: t.object_version_number = l_object_version_number
242: where t.grade_rule_id = p_base_key_value
243: and p_effective_date

Line 296: from pay_grade_rules_f

292: program_id,
293: program_update_date,
294: object_version_number,
295: currency_code
296: from pay_grade_rules_f
297: where grade_rule_id = p_grade_rule_id
298: and p_effective_date
299: between effective_start_date and effective_end_date
300: for update nowait;

Line 353: p_base_table_name => 'pay_grade_rules_f',

349: --
350: dt_api.validate_dt_mode
351: (p_effective_date => p_effective_date,
352: p_datetrack_mode => p_datetrack_mode,
353: p_base_table_name => 'pay_grade_rules_f',
354: p_base_key_column => 'grade_rule_id',
355: p_base_key_value => p_grade_rule_id,
356: p_enforce_foreign_locking => true,
357: p_validation_start_date => l_validation_start_date,

Line 387: hr_utility.set_message_token('TABLE_NAME', 'pay_grade_rules_f');

383: -- The object is locked therefore we need to supply a meaningful
384: -- error message.
385: --
386: hr_utility.set_message(801, 'HR_7165_OBJECT_LOCKED');
387: hr_utility.set_message_token('TABLE_NAME', 'pay_grade_rules_f');
388: hr_utility.raise_error;
389: When l_object_invalid then
390: --
391: -- The object doesn't exist or is invalid

Line 394: hr_utility.set_message_token('TABLE_NAME', 'pay_grade_rules_f');

390: --
391: -- The object doesn't exist or is invalid
392: --
393: hr_utility.set_message(801, 'HR_7155_OBJECT_INVALID');
394: hr_utility.set_message_token('TABLE_NAME', 'pay_grade_rules_f');
395: hr_utility.raise_error;
396: End lck;
397: --
398: -- ----------------------------------------------------------------------------