APPS.PQH_PA_WHATIF_PROCESS dependencies on BEN_PER_INFO_CHG_CS_LER_F

Line 4305: From ben_per_info_chg_cs_ler_f a,

4301: )
4302: RETURN VARCHAR2 IS
4303: Cursor csr_watif_labels IS
4304: Select whatif_lbl_txt label
4305: From ben_per_info_chg_cs_ler_f a,
4306: ben_ler_per_info_cs_ler_f b
4307: Where a.PER_INFO_CHG_CS_LER_ID=b.PER_INFO_CHG_CS_LER_ID
4308: and b.ler_id=p_ler_id
4309: and a.WHATIF_LBL_TXT is not null

Line 4313: l_label ben_per_info_chg_cs_ler_f.WHATIF_LBL_TXT%TYPE;

4309: and a.WHATIF_LBL_TXT is not null
4310: and p_effective_date between a.effective_start_date and a.effective_end_date
4311: and p_effective_date between b.effective_start_date and b.effective_end_date;
4312:
4313: l_label ben_per_info_chg_cs_ler_f.WHATIF_LBL_TXT%TYPE;
4314:
4315: BEGIN
4316: OPEN csr_watif_labels;
4317: FETCH csr_watif_labels into l_label;