APPS.BEN_LPR_BUS dependencies on BEN_LER_CHG_PLIP_ENRT_F

Line 123: from ben_ler_chg_plip_enrt_f

119: -- unique in bg, plip, and eff dates
120: --
121: cursor chk_unique is
122: select null
123: from ben_ler_chg_plip_enrt_f
124: where ler_id = p_ler_id
125: and ler_chg_plip_enrt_id <> nvl(p_ler_chg_plip_enrt_id, hr_api.g_number)
126: and plip_id = p_plip_id
127: and business_group_id + 0 = p_business_group_id

Line 689: from ben_ler_chg_plip_enrt_f

685: -- only one 'YES' value is allowed within parent, bg, and eff dates
686: --
687: cursor chk_unique is
688: select null
689: from ben_ler_chg_plip_enrt_f
690: where dflt_flag = p_dflt_flag
691: and dflt_flag = 'Y'
692: and ler_chg_plip_enrt_id <> nvl(p_ler_chg_plip_enrt_id, hr_api.g_number)
693: and plip_id = p_plip_id

Line 1468: ben_ler_chg_plip_enrt_f b

1464: --
1465: cursor csr_leg_code is
1466: select a.legislation_code
1467: from per_business_groups a,
1468: ben_ler_chg_plip_enrt_f b
1469: where b.ler_chg_plip_enrt_id = p_ler_chg_plip_enrt_id
1470: and a.business_group_id = b.business_group_id;
1471: --
1472: -- Declare local variables