APPS.BEN_EXTRACT_SEED dependencies on BEN_LER_V

Line 455: from ben_ler_v

451: where lookup_type = 'BEN_EXT_SUSPEND'
452: and lookup_code = p_val;
453:
454: cursor ch is select name
455: from ben_ler_v
456: where business_group_id = p_business_group_id
457: and trunc(sysdate) between nvl(effective_start_date,trunc(sysdate))
458: and nvl(effective_end_date,trunc(sysdate))
459: and ler_id = p_val;

Line 1220: from ben_ler_v

1216: where lookup_type = 'BEN_EXT_SUSPEND'
1217: and meaning = p_meaning;
1218:
1219: cursor ch is select name
1220: from ben_ler_v
1221: where business_group_id = p_business_group_id
1222: and trunc(sysdate) between nvl(effective_start_date,trunc(sysdate))
1223: and nvl(effective_end_date,trunc(sysdate))
1224: and ler_id = p_val_1;