APPS.PQP_PTY_SHD dependencies on PQP_PENSION_TYPES_F

Line 142: from pqp_pension_types_f

138: ,ee_age_threshold -- added for ABP TAR fixes
139: ,er_age_threshold -- added for ABP TAR fixes
140: ,ee_age_contribution -- added for ABP TAR fixes
141: ,er_age_contribution -- added for ABP TAR fixes
142: from pqp_pension_types_f
143: where pension_type_id = p_pension_type_id
144: and p_effective_date
145: between effective_start_date and effective_end_date;
146: --

Line 217: ,p_base_table_name => 'pqp_pension_types_f'

213: -- Call the corresponding datetrack api
214: --
215: dt_api.find_dt_upd_modes
216: (p_effective_date => p_effective_date
217: ,p_base_table_name => 'pqp_pension_types_f'
218: ,p_base_key_column => 'pension_type_id'
219: ,p_base_key_value => p_base_key_value
220: ,p_correction => p_correction
221: ,p_update => p_update

Line 251: ,p_base_table_name => 'pqp_pension_types_f'

247: -- Call the corresponding datetrack api
248: --
249: dt_api.find_dt_del_modes
250: (p_effective_date => p_effective_date
251: ,p_base_table_name => 'pqp_pension_types_f'
252: ,p_base_key_column => 'pension_type_id'
253: ,p_base_key_value => p_base_key_value
254: ,p_zap => p_zap
255: ,p_delete => p_delete

Line 286: (p_base_table_name => 'pqp_pension_types_f'

282: -- version number.
283: --
284: l_object_version_number :=
285: dt_api.get_object_version_number
286: (p_base_table_name => 'pqp_pension_types_f'
287: ,p_base_key_column => 'pension_type_id'
288: ,p_base_key_value => p_base_key_value
289: );
290: --

Line 297: update pqp_pension_types_f t

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

Line 426: from pqp_pension_types_f

422: ,ee_age_threshold -- added for ABP TAR fixes
423: ,er_age_threshold -- added for ABP TAR fixes
424: ,ee_age_contribution -- added for ABP TAR fixes
425: ,er_age_contribution -- added for ABP TAR fixes
426: from pqp_pension_types_f
427: where pension_type_id = p_pension_type_id
428: and p_effective_date
429: between effective_start_date and effective_end_date
430: for update nowait;

Line 489: ,p_base_table_name => 'pqp_pension_types_f'

485: --
486: dt_api.validate_dt_mode
487: (p_effective_date => p_effective_date
488: ,p_datetrack_mode => p_datetrack_mode
489: ,p_base_table_name => 'pqp_pension_types_f'
490: ,p_base_key_column => 'pension_type_id'
491: ,p_base_key_value => p_pension_type_id
492: ,p_enforce_foreign_locking => true
493: ,p_validation_start_date => l_validation_start_date

Line 524: fnd_message.set_token('TABLE_NAME', 'pqp_pension_types_f');

520: -- The object is locked therefore we need to supply a meaningful
521: -- error message.
522: --
523: fnd_message.set_name('PAY', 'HR_7165_OBJECT_LOCKED');
524: fnd_message.set_token('TABLE_NAME', 'pqp_pension_types_f');
525: fnd_message.raise_error;
526: End lck;
527: --
528: -- ----------------------------------------------------------------------------