DBA Data[Home] [Help]

APPS.BEN_EXT_EVALUATE_INCLUSION dependencies on BEN_POPL_RPTG_GRP_F

Line 1110: FROM ben_popl_rptg_grp_f rg,

1106: --
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

Line 1118: l_val_1 ben_popl_rptg_grp_f.pl_id%type;

1114: and rg.pl_id is not null
1115: and ben_ext_person.g_benefits_ext_dt between rg.effective_start_date
1116: and rg.effective_end_date;
1117: --
1118: l_val_1 ben_popl_rptg_grp_f.pl_id%type;
1119: l_proc varchar2(72);
1120: l_index binary_integer := 0;
1121: --
1122: Begin