DBA Data[Home] [Help]

APPS.BEN_PCD_INS dependencies on BEN_PER_CM_F

Line 352: from ben_cm_typ_f cct, ben_per_cm_f pcm

348:
349: -- find the maximum number of times this communication can be sent
350: cursor c2 is
351: select mx_num_avlbl_val
352: from ben_cm_typ_f cct, ben_per_cm_f pcm
353: where pcm.per_cm_id = p_rec.per_cm_id
354: and pcm.cm_typ_id = cct.cm_typ_id
355: and p_effective_date between
356: pcm.effective_start_date and pcm.effective_end_date

Line 597: p_parent_table_name1 => 'ben_per_cm_f',

593: p_datetrack_mode => p_datetrack_mode,
594: p_base_table_name => 'ben_per_cm_prvdd_f',
595: p_base_key_column => 'per_cm_prvdd_id',
596: p_base_key_value => p_rec.per_cm_prvdd_id,
597: p_parent_table_name1 => 'ben_per_cm_f',
598: p_parent_key_column1 => 'per_cm_id',
599: p_parent_key_value1 => p_rec.per_cm_id,
600: p_enforce_foreign_locking => true,
601: p_validation_start_date => l_validation_start_date,