APPS.PAY_CNT_SHD dependencies on PAY_US_EMP_COUNTY_TAX_RULES_F

Line 160: from pay_us_emp_county_tax_rules_f

156: cnt_information27,
157: cnt_information28,
158: cnt_information29,
159: cnt_information30
160: from pay_us_emp_county_tax_rules_f
161: where emp_county_tax_rule_id = p_emp_county_tax_rule_id
162: and p_effective_date
163: between effective_start_date and effective_end_date;
164: --

Line 240: p_base_table_name => 'pay_us_emp_county_tax_rules_f',

236: -- Call the corresponding datetrack api
237: --
238: dt_api.find_dt_del_modes
239: (p_effective_date => p_effective_date,
240: p_base_table_name => 'pay_us_emp_county_tax_rules_f',
241: p_base_key_column => 'emp_county_tax_rule_id',
242: p_base_key_value => p_base_key_value,
243: p_zap => p_zap,
244: p_delete => p_delete,

Line 271: p_base_table_name => 'pay_us_emp_county_tax_rules_f',

267: -- Call the corresponding datetrack api
268: --
269: dt_api.find_dt_upd_modes
270: (p_effective_date => p_effective_date,
271: p_base_table_name => 'pay_us_emp_county_tax_rules_f',
272: p_base_key_column => 'emp_county_tax_rule_id',
273: p_base_key_value => p_base_key_value,
274: p_correction => p_correction,
275: p_update => p_update,

Line 304: (p_base_table_name => 'pay_us_emp_county_tax_rules_f',

300: -- version number.
301: --
302: l_object_version_number :=
303: dt_api.get_object_version_number
304: (p_base_table_name => 'pay_us_emp_county_tax_rules_f',
305: p_base_key_column => 'emp_county_tax_rule_id',
306: p_base_key_value => p_base_key_value);
307: --
308: hr_utility.set_location(l_proc, 10);

Line 314: update pay_us_emp_county_tax_rules_f t

310: --
311: -- Update the specified datetrack row setting the effective
312: -- end date to the specified new effective end date.
313: --
314: update pay_us_emp_county_tax_rules_f t
315: set t.effective_end_date = p_new_effective_end_date,
316: t.object_version_number = l_object_version_number
317: where t.emp_county_tax_rule_id = p_base_key_value
318: and p_effective_date

Line 435: from pay_us_emp_county_tax_rules_f

431: cnt_information27,
432: cnt_information28,
433: cnt_information29,
434: cnt_information30
435: from pay_us_emp_county_tax_rules_f
436: where emp_county_tax_rule_id = p_emp_county_tax_rule_id
437: and p_effective_date
438: between effective_start_date and effective_end_date
439: for update nowait;

Line 494: p_base_table_name => 'pay_us_emp_county_tax_rules_f',

490: --
491: dt_api.validate_dt_mode
492: (p_effective_date => p_effective_date,
493: p_datetrack_mode => p_datetrack_mode,
494: p_base_table_name => 'pay_us_emp_county_tax_rules_f',
495: p_base_key_column => 'emp_county_tax_rule_id',
496: p_base_key_value => p_emp_county_tax_rule_id,
497:
498: p_enforce_foreign_locking => true,

Line 530: 'pay_us_emp_county_tax_rules_f');

526: -- error message.
527: --
528: hr_utility.set_message(801, 'HR_7165_OBJECT_LOCKED');
529: hr_utility.set_message_token('TABLE_NAME',
530: 'pay_us_emp_county_tax_rules_f');
531: hr_utility.raise_error;
532: When l_object_invalid then
533: --
534: -- The object doesn't exist or is invalid

Line 538: 'pay_us_emp_county_tax_rules_f');

534: -- The object doesn't exist or is invalid
535: --
536: hr_utility.set_message(801, 'HR_7155_OBJECT_INVALID');
537: hr_utility.set_message_token('TABLE_NAME',
538: 'pay_us_emp_county_tax_rules_f');
539: hr_utility.raise_error;
540: End lck;
541: --
542: -- ----------------------------------------------------------------------------