486: and nvl(effective_end_date,trunc(sysdate))
487: and pl_id = p_val;
488: /*
489: cursor cf is select name
490: from ben_rptg_grp_v
491: WHERE nvl(business_group_id,nvl(p_business_group_id,-1))
492: = nvl(p_business_group_id,-1)
493: and rptg_grp_id = p_val;
494: */
527: and nvl(effective_end_date,trunc(sysdate))
528: and pl_id = p_val;
529:
530: cursor ck is select name
531: from ben_rptg_grp_v
532: where business_group_id = p_business_group_id
533: and rptg_grp_id = p_val;
534:
535:
1253: and nvl(effective_end_date,trunc(sysdate))
1254: and name = p_meaning ;
1255: /*
1256: cursor cf is select name
1257: from ben_rptg_grp_v
1258: where business_group_id = p_business_group_id
1259: and rptg_grp_id = p_val_1;
1260: */
1261:
1292: and nvl(effective_end_date,trunc(sysdate))
1293: and name = p_meaning ;
1294:
1295: cursor ck is select rptg_grp_id
1296: from ben_rptg_grp_v
1297: where business_group_id = p_business_group_id
1298: and name = p_meaning ;
1299:
1300: cursor cl is select lookup_code