547: and pl_typ_id = p_val;
548:
549:
550: cursor cn is select start_date||' - '||end_date
551: from ben_yr_perd
552: where business_group_id = p_business_group_id
553: and yr_perd_id = p_val;
554:
555: cursor co is select meaning
1311: and name = p_meaning;
1312:
1313:
1314: cursor cn is select yr_perd_id
1315: from ben_yr_perd
1316: where business_group_id = p_business_group_id
1317: and start_date||' - '||end_date = p_meaning;
1318:
1319: cursor co is select lookup_code