APPS.BEN_LPL_BUS dependencies on BEN_PER_INFO_CHG_CS_LER_F

Line 123: from ben_per_info_chg_cs_ler_f a

119: l_dummy varchar2(1);
120: --
121: cursor c1 is
122: select null
123: from ben_per_info_chg_cs_ler_f a
124: where a.per_info_chg_cs_ler_id = p_per_info_chg_cs_ler_id
125: and p_effective_date between effective_start_date
126: and effective_end_date;
127:

Line 164: -- ben_per_info_chg_cs_ler_f table

160: <> nvl(ben_lpl_shd.g_old_rec.per_info_chg_cs_ler_id,hr_api.g_number)
161: or not l_api_updating) then
162: --
163: -- check if per_info_chg_cs_ler_id value exists in
164: -- ben_per_info_chg_cs_ler_f table
165: open c1;
166: fetch c1 into l_dummy;
167: if c1%notfound then
168: close c1;

Line 511: from ben_per_info_chg_cs_ler_f psl

507: l_dummy varchar2(1);
508: --
509: cursor c_source_table is
510: select psl.source_table
511: from ben_per_info_chg_cs_ler_f psl
512: where psl.per_info_chg_cs_ler_id = p_per_info_chg_cs_ler_id
513: and p_effective_date
514: between psl.effective_start_date
515: and psl.effective_end_date;

Line 522: ben_per_info_chg_cs_ler_f psl

518: --
519: cursor c_check_multiple(p_source_table varchar2) is
520: select null
521: from ben_ler_per_info_cs_ler_f lpl,
522: ben_per_info_chg_cs_ler_f psl
523: where lpl.ler_per_info_cs_ler_id <> nvl(p_ler_per_info_cs_ler_id,-1)
524: and lpl.ler_id = p_ler_id
525: and p_effective_date
526: between lpl.effective_start_date