APPS.BEN_PQC_SHD dependencies on BEN_PRTT_RMT_RQST_CTFN_PRVDD_F

Line 102: from ben_prtt_rmt_rqst_ctfn_prvdd_f

98: ,pqc_attribute28
99: ,pqc_attribute29
100: ,pqc_attribute30
101: ,object_version_number
102: from ben_prtt_rmt_rqst_ctfn_prvdd_f
103: where prtt_rmt_rqst_ctfn_prvdd_id = p_prtt_rmt_rqst_ctfn_prvdd_id
104: and p_effective_date
105: between effective_start_date and effective_end_date;
106: --

Line 178: ,p_base_table_name => 'ben_prtt_rmt_rqst_ctfn_prvdd_f'

174: -- Call the corresponding datetrack api
175: --
176: dt_api.find_dt_upd_modes
177: (p_effective_date => p_effective_date
178: ,p_base_table_name => 'ben_prtt_rmt_rqst_ctfn_prvdd_f'
179: ,p_base_key_column => 'prtt_rmt_rqst_ctfn_prvdd_id'
180: ,p_base_key_value => p_base_key_value
181: ,p_correction => p_correction
182: ,p_update => p_update

Line 211: from ben_prtt_rmt_rqst_ctfn_prvdd_f t

207: Cursor C_Sel1 Is
208: select
209: t.pl_gd_r_svc_ctfn_id
210: ,t.prtt_enrt_actn_id
211: from ben_prtt_rmt_rqst_ctfn_prvdd_f t
212: where t.prtt_rmt_rqst_ctfn_prvdd_id = p_base_key_value
213: and p_effective_date
214: between t.effective_start_date and t.effective_end_date;
215: --

Line 235: ,p_base_table_name => 'ben_prtt_rmt_rqst_ctfn_prvdd_f'

231: -- Call the corresponding datetrack api
232: --
233: dt_api.find_dt_del_modes
234: (p_effective_date => p_effective_date
235: ,p_base_table_name => 'ben_prtt_rmt_rqst_ctfn_prvdd_f'
236: ,p_base_key_column => 'prtt_rmt_rqst_ctfn_prvdd_id'
237: ,p_base_key_value => p_base_key_value
238: ,p_parent_table_name1 => 'ben_pl_gd_r_svc_ctfn_f'
239: ,p_parent_key_column1 => 'pl_gd_r_svc_ctfn_id'

Line 276: (p_base_table_name => 'ben_prtt_rmt_rqst_ctfn_prvdd_f'

272: -- version number.
273: --
274: l_object_version_number :=
275: dt_api.get_object_version_number
276: (p_base_table_name => 'ben_prtt_rmt_rqst_ctfn_prvdd_f'
277: ,p_base_key_column => 'prtt_rmt_rqst_ctfn_prvdd_id'
278: ,p_base_key_value => p_base_key_value
279: );
280: --

Line 287: update ben_prtt_rmt_rqst_ctfn_prvdd_f t

283: --
284: -- Update the specified datetrack row setting the effective
285: -- end date to the specified new effective end date.
286: --
287: update ben_prtt_rmt_rqst_ctfn_prvdd_f t
288: set t.effective_end_date = p_new_effective_end_date
289: , t.object_version_number = l_object_version_number
290: where t.prtt_rmt_rqst_ctfn_prvdd_id = p_base_key_value
291: and p_effective_date

Line 370: from ben_prtt_rmt_rqst_ctfn_prvdd_f

366: ,pqc_attribute28
367: ,pqc_attribute29
368: ,pqc_attribute30
369: ,object_version_number
370: from ben_prtt_rmt_rqst_ctfn_prvdd_f
371: where prtt_rmt_rqst_ctfn_prvdd_id = p_prtt_rmt_rqst_ctfn_prvdd_id
372: and p_effective_date
373: between effective_start_date and effective_end_date
374: for update nowait;

Line 433: ,p_base_table_name => 'ben_prtt_rmt_rqst_ctfn_prvdd_f'

429: --
430: dt_api.validate_dt_mode
431: (p_effective_date => p_effective_date
432: ,p_datetrack_mode => p_datetrack_mode
433: ,p_base_table_name => 'ben_prtt_rmt_rqst_ctfn_prvdd_f'
434: ,p_base_key_column => 'prtt_rmt_rqst_ctfn_prvdd_id'
435: ,p_base_key_value => p_prtt_rmt_rqst_ctfn_prvdd_id
436: ,p_parent_table_name1 => 'ben_pl_gd_r_svc_ctfn_f'
437: ,p_parent_key_column1 => 'pl_gd_r_svc_ctfn_id'

Line 474: fnd_message.set_token('TABLE_NAME', 'ben_prtt_rmt_rqst_ctfn_prvdd_f');

470: -- The object is locked therefore we need to supply a meaningful
471: -- error message.
472: --
473: fnd_message.set_name('PAY', 'HR_7165_OBJECT_LOCKED');
474: fnd_message.set_token('TABLE_NAME', 'ben_prtt_rmt_rqst_ctfn_prvdd_f');
475: fnd_message.raise_error;
476: End lck;
477: --
478: -- ----------------------------------------------------------------------------