APPS.BEN_PCM_BUS dependencies on BEN_CM_TYP_F

Line 118: from ben_cm_typ_f cmt

114: asg.effective_start_date and asg.effective_end_date;
115: --
116: cursor c_cmtyp is
117: select cmt.cm_typ_rl
118: from ben_cm_typ_f cmt
119: where cmt.cm_typ_id = p_cm_typ_id and
120: cmt.business_group_id = p_business_group_id and
121: p_effective_date between
122: cmt.effective_start_date and cmt.effective_end_date;

Line 138: -- Get cm_typ_rl from ben_cm_typ_f table.

134: -- close c_asg;
135: -- end if;
136: -- close c_asg;
137: --
138: -- Get cm_typ_rl from ben_cm_typ_f table.
139: --
140: open c_cmtyp;
141: fetch c_cmtyp into l_cm_typ_rl;
142: close c_cmtyp;

Line 249: (p_base_table_name => 'ben_cm_typ_f',

245: p_argument_value => p_validation_end_date);
246: --
247: If ((nvl(p_cm_typ_id, hr_api.g_number) <> hr_api.g_number) and
248: NOT (dt_api.check_min_max_dates
249: (p_base_table_name => 'ben_cm_typ_f',
250: p_base_key_column => 'cm_typ_id',
251: p_base_key_value => p_cm_typ_id,
252: p_from_date => p_validation_start_date,
253: p_to_date => p_validation_end_date))) Then

Line 254: l_table_name := 'ben_cm_typ_f';

250: p_base_key_column => 'cm_typ_id',
251: p_base_key_value => p_cm_typ_id,
252: p_from_date => p_validation_start_date,
253: p_to_date => p_validation_end_date))) Then
254: l_table_name := 'ben_cm_typ_f';
255: Raise l_integrity_error;
256: End If;
257: If ((nvl(p_prtt_enrt_actn_id, hr_api.g_number) <> hr_api.g_number) and
258: NOT (dt_api.check_min_max_dates