APPS.BEN_EXT_UTIL dependencies on BEN_EXT_DFN

Line 199: ben_ext_dfn df

195: FROM ben_ext_rslt_dtl d,
196: ben_ext_rcd r,
197: ben_ext_rcd_in_file f,
198: ben_ext_rslt rs,
199: ben_ext_dfn df
200: WHERE d.ext_rslt_id(+) = p_ext_rslt_id
201: AND f.ext_rcd_id = r.ext_rcd_id
202: AND r.ext_rcd_id = d.ext_rcd_id (+)
203: AND f.ext_file_id = df.ext_file_id

Line 217: ben_ext_dfn df

213: FROM ben_ext_rslt_dtl d,
214: ben_ext_rcd r,
215: ben_ext_rcd_in_file f,
216: ben_ext_rslt rs,
217: ben_ext_dfn df
218: WHERE d.ext_rslt_id(+) = p_ext_rslt_id
219: AND d.request_id(+) = p_request_id
220: AND f.ext_rcd_id = r.ext_rcd_id
221: AND r.ext_rcd_id = d.ext_rcd_id (+)

Line 244: ben_ext_dfn df

240: SELECT count(r.name) count
241: FROM ben_ext_rcd r,
242: ben_ext_rcd_in_file f,
243: ben_ext_rslt rs,
244: ben_ext_dfn df
245: WHERE f.ext_rcd_id = r.ext_rcd_id
246: AND f.ext_file_id = df.ext_file_id
247: AND df.ext_dfn_id = rs.ext_dfn_id
248: AND rs.ext_rslt_id = p_ext_rslt_id

Line 845: ben_ext_dfn xdf

841: cursor c_chg_actl_dt(p_ext_dfn_id in number) is
842: select xcv.val_1, xcv.val_2, xct.excld_flag
843: from ben_ext_crit_val xcv,
844: ben_ext_crit_typ xct,
845: ben_ext_dfn xdf
846: where xdf.ext_dfn_id = p_ext_dfn_id
847: and xdf.ext_crit_prfl_id = xct.ext_crit_prfl_id
848: and xct.ext_crit_typ_id = xcv.ext_crit_typ_id
849: and xct.crit_typ_cd = 'CAD'; -- change actual date

Line 857: ben_ext_dfn xdf

853: cursor c_chg_eff_dt(p_ext_dfn_id in number) is
854: select xcv.val_1, xcv.val_2, xct.excld_flag
855: from ben_ext_crit_val xcv,
856: ben_ext_crit_typ xct,
857: ben_ext_dfn xdf
858: where xdf.ext_dfn_id = p_ext_dfn_id
859: and xdf.ext_crit_prfl_id = xct.ext_crit_prfl_id
860: and xct.ext_crit_typ_id = xcv.ext_crit_typ_id
861: and xct.crit_typ_cd = 'CED'; -- change effective date

Line 947: ben_ext_dfn xdf

943: cursor c_to_be_sent_dt(p_ext_dfn_id in number) is
944: select xcv.val_1, xcv.val_2, xct.excld_flag
945: from ben_ext_crit_val xcv,
946: ben_ext_crit_typ xct,
947: ben_ext_dfn xdf
948: where xdf.ext_dfn_id = p_ext_dfn_id
949: and xdf.ext_crit_prfl_id = xct.ext_crit_prfl_id
950: and xct.ext_crit_typ_id = xcv.ext_crit_typ_id
951: and xct.crit_typ_cd = 'MTBSDT'; -- comm to be sent date

Line 1024: ben_ext_dfn xdf

1020: cursor c_person_dt_cd(p_ext_dfn_id in number) is
1021: select xcv.val_1
1022: from ben_ext_crit_val xcv,
1023: ben_ext_crit_typ xct,
1024: ben_ext_dfn xdf
1025: where xdf.ext_dfn_id = p_ext_dfn_id
1026: and xdf.ext_crit_prfl_id = xct.ext_crit_prfl_id
1027: and xct.ext_crit_typ_id = xcv.ext_crit_typ_id
1028: and xct.crit_typ_cd = 'PASOR'; -- person datetrack override date

Line 1038: ben_ext_dfn xdf

1034: cursor c_benefits_dt_cd(p_ext_dfn_id in number) is
1035: select xcv.val_1
1036: from ben_ext_crit_val xcv,
1037: ben_ext_crit_typ xct,
1038: ben_ext_dfn xdf
1039: where xdf.ext_dfn_id = p_ext_dfn_id
1040: and xdf.ext_crit_prfl_id = xct.ext_crit_prfl_id
1041: and xct.ext_crit_typ_id = xcv.ext_crit_typ_id
1042: and xct.crit_typ_cd = 'BDTOR'; -- benefits datetrack override date