APPS.BEN_PLAN_DESIGN_PROGRAM_MODULE dependencies on BEN_RLTD_PER_CHG_CS_LER_F

Line 6551: l_rltd_per_chg_cs_ler_name ben_rltd_per_chg_cs_ler_f.name%type := null;

6547: p_rltd_per_chg_cs_ler_id in number
6548: ,p_effective_date in date
6549: ) return varchar2 is
6550:
6551: l_rltd_per_chg_cs_ler_name ben_rltd_per_chg_cs_ler_f.name%type := null;
6552:
6553: cursor c_rltd_per_chg_cs_ler_name is
6554: select rcl.name
6555: from ben_rltd_per_chg_cs_ler_f rcl

Line 6555: from ben_rltd_per_chg_cs_ler_f rcl

6551: l_rltd_per_chg_cs_ler_name ben_rltd_per_chg_cs_ler_f.name%type := null;
6552:
6553: cursor c_rltd_per_chg_cs_ler_name is
6554: select rcl.name
6555: from ben_rltd_per_chg_cs_ler_f rcl
6556: where rcl.rltd_per_chg_cs_ler_id = p_rltd_per_chg_cs_ler_id
6557: and p_effective_date between rcl.effective_start_date
6558: and rcl.effective_end_date;
6559: