APPS.PAY_PAY_SHD dependencies on PAY_ALL_PAYROLLS_F

Line 208: from pay_all_payrolls_f

204: ,multi_assignments_flag
205: ,period_reset_years
206: ,object_version_number
207: ,payslip_view_date_offset
208: from pay_all_payrolls_f
209: where payroll_id = p_payroll_id
210: and p_effective_date
211: between effective_start_date and effective_end_date;
212: --

Line 291: ,p_base_table_name => 'pay_all_payrolls_f'

287: -- Call the corresponding datetrack api
288: --
289: dt_api.find_dt_upd_modes
290: (p_effective_date => p_effective_date
291: ,p_base_table_name => 'pay_all_payrolls_f'
292: ,p_base_key_column => 'payroll_id'
293: ,p_base_key_value => p_base_key_value
294: ,p_correction => p_correction
295: ,p_update => p_update

Line 321: from pay_all_payrolls_f t

317: l_parent_key_value1 number;
318: --
319: Cursor C_Sel1 Is
320: select t.default_payment_method_id
321: from pay_all_payrolls_f t
322: where t.payroll_id = p_base_key_value
323: and p_effective_date
324: between t.effective_start_date and t.effective_end_date;
325: --

Line 348: ,p_base_table_name => 'pay_all_payrolls_f'

344: -- Call the corresponding datetrack api
345: --
346: dt_api.find_dt_del_modes
347: (p_effective_date => p_effective_date
348: ,p_base_table_name => 'pay_all_payrolls_f'
349: ,p_base_key_column => 'payroll_id'
350: ,p_base_key_value => p_base_key_value
351:
352: ,p_parent_table_name1 => 'pay_org_payment_methods_f'

Line 391: (p_base_table_name => 'pay_all_payrolls_f'

387: -- version number.
388: --
389: l_object_version_number :=
390: dt_api.get_object_version_number
391: (p_base_table_name => 'pay_all_payrolls_f'
392: ,p_base_key_column => 'payroll_id'
393: ,p_base_key_value => p_base_key_value
394: );
395: --

Line 402: update pay_all_payrolls_f t

398: --
399: -- Update the specified datetrack row setting the effective
400: -- end date to the specified new effective end date.
401: --
402: update pay_all_payrolls_f t
403: set t.effective_end_date = p_new_effective_end_date
404: , t.object_version_number = l_object_version_number
405: where t.payroll_id = p_base_key_value
406: and p_effective_date

Line 536: from pay_all_payrolls_f

532: ,multi_assignments_flag
533: ,period_reset_years
534: ,object_version_number
535: ,payslip_view_date_offset
536: from pay_all_payrolls_f
537: where payroll_id = p_payroll_id
538: and p_effective_date
539: between effective_start_date and effective_end_date
540: for update nowait;

Line 643: ,p_base_table_name => 'pay_all_payrolls_f'

639:
640: dt_api.validate_dt_mode
641: (p_effective_date => p_effective_date
642: ,p_datetrack_mode => p_datetrack_mode
643: ,p_base_table_name => 'pay_all_payrolls_f'
644: ,p_base_key_column => 'payroll_id'
645: ,p_base_key_value => p_payroll_id
646:
647: ,p_parent_table_name1 => 'pay_org_payment_methods_f'

Line 696: fnd_message.set_token('TABLE_NAME', 'pay_all_payrolls_f');

692: -- The object is locked therefore we need to supply a meaningful
693: -- error message.
694: --
695: fnd_message.set_name('PAY', 'HR_7165_OBJECT_LOCKED');
696: fnd_message.set_token('TABLE_NAME', 'pay_all_payrolls_f');
697: fnd_message.raise_error;
698: --
699: End lck;
700: --