DBA Data[Home] [Help]

APPS.BEN_EXTRACT_SEED dependencies on BEN_PL_TYP_F

Line 490: from ben_pl_typ_f

486: and lookup_code = p_val;
487:
488:
489: cursor cm is select name
490: from ben_pl_typ_f
491: where business_group_id = p_business_group_id
492: and trunc(sysdate) between nvl(effective_start_date,trunc(sysdate))
493: and nvl(effective_end_date,trunc(sysdate))
494: and pl_typ_id = p_val;

Line 1254: from ben_pl_typ_f

1250: and meaning = p_meaning;
1251:
1252:
1253: cursor cm is select pl_typ_id
1254: from ben_pl_typ_f
1255: where business_group_id = p_business_group_id
1256: and trunc(sysdate) between nvl(effective_start_date,trunc(sysdate))
1257: and nvl(effective_end_date,trunc(sysdate))
1258: and name = p_meaning;