DBA Data[Home] [Help]

APPS.BEN_GENERATE_COMMUNICATIONS dependencies on BEN_CM_TYP_TRGR_F

Line 4223: ben_cm_typ_trgr_f ctt,

4219: ctr.proc_cd,
4220: cct.rcpent_cd,
4221: cct.name
4222: from ben_cm_trgr ctr,
4223: ben_cm_typ_trgr_f ctt,
4224: ben_cm_typ_f cct,
4225: ben_cm_dlvry_mthd_typ cmt,
4226: ben_cm_dlvry_med_typ cmd
4227: /* if p_cm_trgr_typ_cd is specified pick only those rows */

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

4399: --
4400: -- Steps to generate communications
4401: --
4402: -- 1. Get all communication triggers for BG that are valid as of effective
4403: -- date. Join to ben_cm_typ_trgr_f and ben_cm_typ (Cursor c_triggers).
4404: -- 2. Loop through records
4405: -- 3. Set Savepoint
4406: -- 4. If rule exists and fails then look at next record
4407: -- 5. If whnvr_trgrd_flag = 'Y' then do for all comp objects