DBA Data[Home] [Help]

APPS.BEN_GENERATE_COMMUNICATIONS dependencies on BEN_CM_TRGR

Line 4222: from ben_cm_trgr ctr,

4218: cct.inspn_rqd_rl,
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

Line 4408: -- 4a. Populate ben_cm_trgr_f

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
4408: -- 4a. Populate ben_cm_trgr_f
4409: -- 4b. Populate ben_per_cm_f
4410: -- 4b. Populate ben_per_cm_prvdd_f
4411: -- 6. If whnvr_trgrd_flag = 'N' then join to cm_typ_usg_f
4412: -- 7. If rule exists or no rule and a usage exists