APPS.PAY_CFT_SHD dependencies on PAY_CA_EMP_FED_TAX_INFO_F

Line 122: from pay_ca_emp_fed_tax_info_f

118: object_version_number,
119: fed_lsf_amount,
120: cpp_election_date, --For Bug Number 13258136
121: cpp_revocation_date --For Bug Number 13258136
122: from pay_ca_emp_fed_tax_info_f
123: where emp_fed_tax_inf_id = p_emp_fed_tax_inf_id
124: and p_effective_date
125: between effective_start_date and effective_end_date;
126: --

Line 197: from pay_ca_emp_fed_tax_info_f t

193: l_parent_key_value1 number;
194: --
195: Cursor C_Sel1 Is
196: select t.assignment_id
197: from pay_ca_emp_fed_tax_info_f t
198: where t.emp_fed_tax_inf_id = p_base_key_value
199: and p_effective_date
200: between t.effective_start_date and t.effective_end_date;
201: --

Line 219: p_base_table_name => 'pay_ca_emp_fed_tax_info_f',

215: -- Call the corresponding datetrack api
216: --
217: dt_api.find_dt_del_modes
218: (p_effective_date => p_effective_date,
219: p_base_table_name => 'pay_ca_emp_fed_tax_info_f',
220: p_base_key_column => 'emp_fed_tax_inf_id',
221: p_base_key_value => p_base_key_value,
222: p_parent_table_name1 => 'per_all_assignments_f',
223: p_parent_key_column1 => 'assignment_id',

Line 253: p_base_table_name => 'pay_ca_emp_fed_tax_info_f',

249: -- Call the corresponding datetrack api
250: --
251: dt_api.find_dt_upd_modes
252: (p_effective_date => p_effective_date,
253: p_base_table_name => 'pay_ca_emp_fed_tax_info_f',
254: p_base_key_column => 'emp_fed_tax_inf_id',
255: p_base_key_value => p_base_key_value,
256: p_correction => p_correction,
257: p_update => p_update,

Line 286: (p_base_table_name => 'pay_ca_emp_fed_tax_info_f',

282: -- version number.
283: --
284: l_object_version_number :=
285: dt_api.get_object_version_number
286: (p_base_table_name => 'pay_ca_emp_fed_tax_info_f',
287: p_base_key_column => 'emp_fed_tax_inf_id',
288: p_base_key_value => p_base_key_value);
289: --
290: hr_utility.set_location(l_proc, 10);

Line 296: update pay_ca_emp_fed_tax_info_f t

292: --
293: -- Update the specified datetrack row setting the effective
294: -- end date to the specified new effective end date.
295: --
296: update pay_ca_emp_fed_tax_info_f t
297: set t.effective_end_date = p_new_effective_end_date,
298: t.object_version_number = l_object_version_number
299: where t.emp_fed_tax_inf_id = p_base_key_value
300: and p_effective_date

Line 392: from pay_ca_emp_fed_tax_info_f

388: object_version_number,
389: fed_lsf_amount,
390: cpp_election_date, --For Bug Number 13258136
391: cpp_revocation_date --For Bug Number 13258136
392: from pay_ca_emp_fed_tax_info_f
393: where emp_fed_tax_inf_id = p_emp_fed_tax_inf_id
394: and p_effective_date
395: between effective_start_date and effective_end_date
396: for update nowait;

Line 470: p_base_table_name => 'pay_ca_emp_fed_tax_info_f',

466: --
467: dt_api.validate_dt_mode
468: (p_effective_date => p_effective_date,
469: p_datetrack_mode => p_datetrack_mode,
470: p_base_table_name => 'pay_ca_emp_fed_tax_info_f',
471: p_base_key_column => 'emp_fed_tax_inf_id',
472: p_base_key_value => p_emp_fed_tax_inf_id,
473: p_parent_table_name1 => 'per_all_assignments_f',
474: p_parent_key_column1 => 'assignment_id',

Line 507: hr_utility.set_message_token('TABLE_NAME', 'pay_ca_emp_fed_tax_info_f');

503: -- The object is locked therefore we need to supply a meaningful
504: -- error message.
505: --
506: hr_utility.set_message(800, 'HR_7165_OBJECT_LOCKED');
507: hr_utility.set_message_token('TABLE_NAME', 'pay_ca_emp_fed_tax_info_f');
508: hr_utility.raise_error;
509: When l_object_invalid then
510: --
511: -- The object doesn't exist or is invalid

Line 514: hr_utility.set_message_token('TABLE_NAME', 'pay_ca_emp_fed_tax_info_f');

510: --
511: -- The object doesn't exist or is invalid
512: --
513: hr_utility.set_message(800, 'HR_7155_OBJECT_INVALID');
514: hr_utility.set_message_token('TABLE_NAME', 'pay_ca_emp_fed_tax_info_f');
515: hr_utility.raise_error;
516: End lck;
517: --
518: -- ----------------------------------------------------------------------------