APPS.PAY_CPT_SHD dependencies on PAY_CA_EMP_PROV_TAX_INFO_F

Line 129: from pay_ca_emp_prov_tax_info_f

125: ca_tax_information30,
126: object_version_number,
127: prov_lsp_amount,
128: ppip_exempt_flag
129: from pay_ca_emp_prov_tax_info_f
130: where emp_province_tax_inf_id = p_emp_province_tax_inf_id
131: and p_effective_date
132: between effective_start_date and effective_end_date;
133: --

Line 202: from pay_ca_emp_prov_tax_info_f t

198: l_parent_key_value1 number;
199: --
200: Cursor C_Sel1 Is
201: select t.assignment_id
202: from pay_ca_emp_prov_tax_info_f t
203: where t.emp_province_tax_inf_id = p_base_key_value
204: and p_effective_date
205: between t.effective_start_date and t.effective_end_date;
206: --

Line 224: p_base_table_name => 'pay_ca_emp_prov_tax_info_f',

220: -- Call the corresponding datetrack api
221: --
222: dt_api.find_dt_del_modes
223: (p_effective_date => p_effective_date,
224: p_base_table_name => 'pay_ca_emp_prov_tax_info_f',
225: p_base_key_column => 'emp_province_tax_inf_id',
226: p_base_key_value => p_base_key_value,
227: p_parent_table_name1 => 'per_all_assignments_f',
228: p_parent_key_column1 => 'assignment_id',

Line 264: p_base_table_name => 'pay_ca_emp_prov_tax_info_f',

260: -- Call the corresponding datetrack api
261: --
262: dt_api.find_dt_upd_modes
263: (p_effective_date => p_effective_date,
264: p_base_table_name => 'pay_ca_emp_prov_tax_info_f',
265: p_base_key_column => 'emp_province_tax_inf_id',
266: p_base_key_value => p_base_key_value,
267: p_correction => p_correction,
268: p_update => p_update,

Line 297: (p_base_table_name => 'pay_ca_emp_prov_tax_info_f',

293: -- version number.
294: --
295: l_object_version_number :=
296: dt_api.get_object_version_number
297: (p_base_table_name => 'pay_ca_emp_prov_tax_info_f',
298: p_base_key_column => 'emp_province_tax_inf_id',
299: p_base_key_value => p_base_key_value);
300: --
301: hr_utility.set_location(l_proc, 10);

Line 307: update pay_ca_emp_prov_tax_info_f t

303: --
304: -- Update the specified datetrack row setting the effective
305: -- end date to the specified new effective end date.
306: --
307: update pay_ca_emp_prov_tax_info_f t
308: set t.effective_end_date = p_new_effective_end_date,
309: t.object_version_number = l_object_version_number
310: where t.emp_province_tax_inf_id = p_base_key_value
311: and p_effective_date

Line 410: from pay_ca_emp_prov_tax_info_f

406: ca_tax_information30,
407: object_version_number,
408: prov_lsp_amount,
409: ppip_exempt_flag
410: from pay_ca_emp_prov_tax_info_f
411: where emp_province_tax_inf_id = p_emp_province_tax_inf_id
412: and p_effective_date
413: between effective_start_date and effective_end_date
414: for update nowait;

Line 469: p_base_table_name => 'pay_ca_emp_prov_tax_info_f',

465: --
466: dt_api.validate_dt_mode
467: (p_effective_date => p_effective_date,
468: p_datetrack_mode => p_datetrack_mode,
469: p_base_table_name => 'pay_ca_emp_prov_tax_info_f',
470: p_base_key_column => 'emp_province_tax_inf_id',
471: p_base_key_value => p_emp_province_tax_inf_id,
472: p_parent_table_name1 => 'per_all_assignments_f',
473: p_parent_key_column1 => 'assignment_id',

Line 506: hr_utility.set_message_token('TABLE_NAME', 'pay_ca_emp_prov_tax_info_f');

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

Line 513: hr_utility.set_message_token('TABLE_NAME', 'pay_ca_emp_prov_tax_info_f');

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