607: and trunc(sysdate) between nvl(start_date_active, trunc(sysdate))
608: and nvl(end_date_active, trunc(sysdate)) ;
609:
610: cursor cep is select event_group_name
611: from pay_event_groups
612: where event_group_id = p_val
613: ;
614:
615: cursor cx is select user_name
1372: and trunc(sysdate) between nvl(start_date_active, trunc(sysdate))
1373: and nvl(end_date_active, trunc(sysdate))
1374: ;
1375: cursor cep is select event_group_id
1376: from pay_event_groups
1377: where event_group_name = p_meaning
1378: and nvl(business_group_id,nvl(p_business_group_id,-1))
1379: = nvl(p_business_group_id,-1)
1380: ;
4719:
4720: l_return varchar2(250) ;
4721:
4722: cursor cep is select event_group_name
4723: from pay_event_groups
4724: where event_group_id = p_CHG_EVT_CD
4725:
4726: ;
4727:
4751:
4752: l_return varchar2(250) ;
4753:
4754: cursor cep is select event_group_id
4755: from pay_event_groups
4756: where event_group_name = P_CHG_EVT_CD
4757: and nvl(business_group_id,nvl(p_business_group_id,-1))
4758: = nvl(p_business_group_id,-1)
4759: ;