DBA Data[Home] [Help]

APPS.BEN_GENERATE_COMMUNICATIONS dependencies on BEN_CM_TRGR

Line 4551: from ben_cm_trgr ctr,

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

Line 4742: -- 4a. Populate ben_cm_trgr_f

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
4742: -- 4a. Populate ben_cm_trgr_f
4743: -- 4b. Populate ben_per_cm_f
4744: -- 4b. Populate ben_per_cm_prvdd_f
4745: -- 6. If whnvr_trgrd_flag = 'N' then join to cm_typ_usg_f
4746: -- 7. If rule exists or no rule and a usage exists