APPS.BEN_EXTRACT_SEED dependencies on BEN_LER_V

Line 508: from ben_ler_v

504: where lookup_type = 'BEN_EXT_SUSPEND'
505: and lookup_code = p_val;
506:
507: cursor ch is select name
508: from ben_ler_v
509: where business_group_id = p_business_group_id
510: and trunc(sysdate) between nvl(effective_start_date,trunc(sysdate))
511: and nvl(effective_end_date,trunc(sysdate))
512: and ler_id = p_val;

Line 1273: from ben_ler_v

1269: where lookup_type = 'BEN_EXT_SUSPEND'
1270: and meaning = p_meaning;
1271:
1272: cursor ch is select name
1273: from ben_ler_v
1274: where business_group_id = p_business_group_id
1275: and trunc(sysdate) between nvl(effective_start_date,trunc(sysdate))
1276: and nvl(effective_end_date,trunc(sysdate))
1277: and ler_id = p_val_1;