DBA Data[Home] [Help]

APPS.BEN_EXTRACT_SEED dependencies on BEN_PL_TYP_F

Line 543: from ben_pl_typ_f

539: and lookup_code = p_val;
540:
541:
542: cursor cm is select name
543: from ben_pl_typ_f
544: where business_group_id = p_business_group_id
545: and trunc(sysdate) between nvl(effective_start_date,trunc(sysdate))
546: and nvl(effective_end_date,trunc(sysdate))
547: and pl_typ_id = p_val;

Line 1307: from ben_pl_typ_f

1303: and meaning = p_meaning;
1304:
1305:
1306: cursor cm is select pl_typ_id
1307: from ben_pl_typ_f
1308: where business_group_id = p_business_group_id
1309: and trunc(sysdate) between nvl(effective_start_date,trunc(sysdate))
1310: and nvl(effective_end_date,trunc(sysdate))
1311: and name = p_meaning;