DBA Data[Home] [Help]

APPS.BEN_GENERATE_COMMUNICATIONS dependencies on BEN_CM_TYP_F

Line 287: and obj.table_name = 'BEN_CM_TYP_F'

283: where p_eff_date between obj.effective_start_date
284: and obj.effective_end_date
285: and p_eff_date between obe.effective_start_date
286: and obe.effective_end_date
287: and obj.table_name = 'BEN_CM_TYP_F'
288: and obj.column_name = 'CM_TYP_ID'
289: and obj.column_value = p_cm_typ_id
290: and obj.business_group_id = p_business_group_id
291: and obe.business_group_id = p_business_group_id

Line 4553: ben_cm_typ_f cct,

4549: cct.rcpent_cd,
4550: cct.name
4551: from ben_cm_trgr ctr,
4552: ben_cm_typ_trgr_f ctt,
4553: ben_cm_typ_f cct,
4554: ben_cm_dlvry_mthd_typ cmt,
4555: ben_cm_dlvry_med_typ cmd
4556: /* if p_cm_trgr_typ_cd is specified pick only those rows */
4557: where ctr.cm_trgr_typ_cd = nvl(p_cm_trgr_typ_cd, ctr.cm_trgr_typ_cd)