DBA Data[Home] [Help]

APPS.BEN_GENERATE_COMMUNICATIONS dependencies on BEN_CM_TYP_TRGR_F

Line 4552: ben_cm_typ_trgr_f ctt,

4548: ctr.proc_cd,
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 */

Line 4737: -- date. Join to ben_cm_typ_trgr_f and ben_cm_typ (Cursor c_triggers).

4733: --
4734: -- Steps to generate communications
4735: --
4736: -- 1. Get all communication triggers for BG that are valid as of effective
4737: -- date. Join to ben_cm_typ_trgr_f and ben_cm_typ (Cursor c_triggers).
4738: -- 2. Loop through records
4739: -- 3. Set Savepoint
4740: -- 4. If rule exists and fails then look at next record
4741: -- 5. If whnvr_trgrd_flag = 'Y' then do for all comp objects