APPS.BEN_EXT_UTIL dependencies on BEN_EXT_CRIT_VAL

Line 847: from ben_ext_crit_val xcv,

843: p_chg_eff_end_dt out nocopy date) is
844: --
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

Line 859: from ben_ext_crit_val xcv,

855:
856: --
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

Line 949: from ben_ext_crit_val xcv,

945: p_to_be_sent_end_dt out nocopy date) is
946: --
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

Line 1026: from ben_ext_crit_val xcv,

1022: --
1023: /*
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

Line 1034: l_person_dt_cd ben_ext_crit_val.val_1%TYPE; -- UTF8 varchar2(30);

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
1033: */
1034: l_person_dt_cd ben_ext_crit_val.val_1%TYPE; -- UTF8 varchar2(30);
1035: l_person_dt date;
1036: --
1037: /*
1038: cursor c_benefits_dt_cd(p_ext_dfn_id in number) is

Line 1040: from ben_ext_crit_val xcv,

1036: --
1037: /*
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

Line 1050: l_benefits_dt_cd ben_ext_crit_val.val_1%TYPE; -- UTF8 varchar2(30);

1046: and xct.crit_typ_cd = 'BDTOR'; -- benefits datetrack override date
1047: */
1048:
1049: l_dummy varchar2(1) ;
1050: l_benefits_dt_cd ben_ext_crit_val.val_1%TYPE; -- UTF8 varchar2(30);
1051: l_benefits_dt date;
1052: ---
1053: cursor c_asg_exist is
1054: select 'x' from