APPS.BEN_EXT_UTIL dependencies on BEN_EXT_DFN

Line 201: ben_ext_dfn df

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

Line 219: ben_ext_dfn df

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

Line 246: ben_ext_dfn df

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

Line 849: ben_ext_dfn xdf

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

Line 861: ben_ext_dfn xdf

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

Line 951: ben_ext_dfn xdf

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

Line 1028: ben_ext_dfn xdf

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

Line 1042: ben_ext_dfn xdf

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