APPS.BEN_PLAN_DESIGN_PROGRAM_MODULE dependencies on BEN_RLTD_PER_CHG_CS_LER_F

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

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

Line 6554: from ben_rltd_per_chg_cs_ler_f rcl

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