eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

APPS.BEN_EXT_EVALUATE_INCLUSION dependencies on BEN_EXT_CRIT_VAL

Line 851: FROM ben_ext_crit_val

847: is
848: --
849: CURSOR get_values IS
850: SELECT val_1
851: FROM ben_ext_crit_val
852: WHERE ext_crit_typ_id = p_crit_typ_id;
853: --
854: l_val_1 ben_ext_crit_val.val_1%type;
855: l_proc varchar2(72);

Line 854: l_val_1 ben_ext_crit_val.val_1%type;

850: SELECT val_1
851: FROM ben_ext_crit_val
852: WHERE ext_crit_typ_id = p_crit_typ_id;
853: --
854: l_val_1 ben_ext_crit_val.val_1%type;
855: l_proc varchar2(72);
856: --- more then one criteria validated for pgm,pl,opt,pl_typ id so all the crieria will be calling the
857: -- same function to store the value
858: -- now the dups are not validated , can be done in future

Line 897: FROM ben_ext_crit_val

893: is
894: --
895: CURSOR get_values IS
896: SELECT val_1
897: FROM ben_ext_crit_val
898: WHERE ext_crit_typ_id = p_crit_typ_id;
899: --
900: l_val_1 ben_ext_crit_val.val_1%type;
901: l_proc varchar2(72);

Line 900: l_val_1 ben_ext_crit_val.val_1%type;

896: SELECT val_1
897: FROM ben_ext_crit_val
898: WHERE ext_crit_typ_id = p_crit_typ_id;
899: --
900: l_val_1 ben_ext_crit_val.val_1%type;
901: l_proc varchar2(72);
902: --- more then one criteria validated for pgm,pl,opt,pl_typ id so all the crieria will be calling the
903: -- same function to store the value
904: -- now the dups are not validated , can be done in future

Line 945: FROM ben_ext_crit_val

941: is
942: --
943: CURSOR get_values IS
944: SELECT val_1, val_2
945: FROM ben_ext_crit_val
946: WHERE ext_crit_typ_id = p_crit_typ_id;
947: --
948: l_val_1 ben_ext_crit_val.val_1%type;
949: l_val_2 ben_ext_crit_val.val_2%type;

Line 948: l_val_1 ben_ext_crit_val.val_1%type;

944: SELECT val_1, val_2
945: FROM ben_ext_crit_val
946: WHERE ext_crit_typ_id = p_crit_typ_id;
947: --
948: l_val_1 ben_ext_crit_val.val_1%type;
949: l_val_2 ben_ext_crit_val.val_2%type;
950: l_proc varchar2(72);
951: l_index binary_integer := 0;
952: --

Line 949: l_val_2 ben_ext_crit_val.val_2%type;

945: FROM ben_ext_crit_val
946: WHERE ext_crit_typ_id = p_crit_typ_id;
947: --
948: l_val_1 ben_ext_crit_val.val_1%type;
949: l_val_2 ben_ext_crit_val.val_2%type;
950: l_proc varchar2(72);
951: l_index binary_integer := 0;
952: --
953: Begin

Line 991: FROM ben_ext_crit_val

987: is
988: --
989: CURSOR get_values IS
990: SELECT val_1, val_2
991: FROM ben_ext_crit_val
992: WHERE ext_crit_typ_id = p_crit_typ_id;
993: --
994: l_val_1 ben_ext_crit_val.val_1%type;
995: l_val_2 ben_ext_crit_val.val_2%type;

Line 994: l_val_1 ben_ext_crit_val.val_1%type;

990: SELECT val_1, val_2
991: FROM ben_ext_crit_val
992: WHERE ext_crit_typ_id = p_crit_typ_id;
993: --
994: l_val_1 ben_ext_crit_val.val_1%type;
995: l_val_2 ben_ext_crit_val.val_2%type;
996: l_proc varchar2(72);
997: l_index binary_integer := 0;
998: --

Line 995: l_val_2 ben_ext_crit_val.val_2%type;

991: FROM ben_ext_crit_val
992: WHERE ext_crit_typ_id = p_crit_typ_id;
993: --
994: l_val_1 ben_ext_crit_val.val_1%type;
995: l_val_2 ben_ext_crit_val.val_2%type;
996: l_proc varchar2(72);
997: l_index binary_integer := 0;
998: --
999: --

Line 1041: FROM ben_ext_crit_val

1037: is
1038: --
1039: CURSOR get_values IS
1040: SELECT ext_crit_val_id
1041: FROM ben_ext_crit_val
1042: WHERE ext_crit_typ_id = p_crit_typ_id
1043: ORDER BY ext_crit_val_id;
1044: --
1045: CURSOR get_cmbn(p_crit_val_id ben_ext_crit_val.ext_crit_val_id%type) IS

Line 1045: CURSOR get_cmbn(p_crit_val_id ben_ext_crit_val.ext_crit_val_id%type) IS

1041: FROM ben_ext_crit_val
1042: WHERE ext_crit_typ_id = p_crit_typ_id
1043: ORDER BY ext_crit_val_id;
1044: --
1045: CURSOR get_cmbn(p_crit_val_id ben_ext_crit_val.ext_crit_val_id%type) IS
1046: SELECT ext_crit_val_id,
1047: crit_typ_cd,
1048: oper_cd,
1049: val_1,

Line 1056: l_crit_val_id ben_ext_crit_val.ext_crit_val_id%type;

1052: WHERE ext_crit_val_id = p_crit_val_id;
1053:
1054: l_get_cmbn get_cmbn%rowtype;
1055: --
1056: l_crit_val_id ben_ext_crit_val.ext_crit_val_id%type;
1057: l_proc varchar2(72);
1058: l_index_val binary_integer := 0;
1059: l_index_cmbn binary_integer := 0;
1060: --

Line 1111: ben_ext_crit_val xcv

1107: --
1108: CURSOR get_values is
1109: SELECT pl_id
1110: FROM ben_popl_rptg_grp_f rg,
1111: ben_ext_crit_val xcv
1112: WHERE to_char(rg.rptg_grp_id) = xcv.val_1
1113: and xcv.ext_crit_typ_id = p_crit_typ_id
1114: and rg.pl_id is not null
1115: and ben_ext_person.g_benefits_ext_dt between rg.effective_start_date