DBA Data[Home] [Help]

APPS.BEN_EXTRACT_SEED dependencies on BEN_LER_F

Line 441: from ben_ler_f

437: and effective_end_date
438: and formula_id = p_val;
439:
440: cursor c9 is select name
441: from ben_ler_f
442: where nvl(business_group_id,nvl(p_business_group_id,-1))
443: = nvl(p_business_group_id,-1)
444: and trunc(sysdate) between effective_start_date
445: and effective_end_date

Line 1204: from ben_ler_f

1200: trunc(sysdate) between effective_start_date
1201: and effective_end_date
1202: and formula_name = p_meaning;
1203: cursor c9 is select ler_id
1204: from ben_ler_f
1205: where nvl(business_group_id,nvl(p_business_group_id,-1))
1206: = nvl(p_business_group_id,-1)
1207: and trunc(sysdate) between effective_start_date
1208: and effective_end_date