DBA Data[Home] [Help]

APPS.BEN_EXTRACT_SEED dependencies on PAY_EVENT_GROUPS

Line 611: from pay_event_groups

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

Line 1376: from pay_event_groups

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: ;

Line 4723: from pay_event_groups

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:

Line 4755: from pay_event_groups

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: ;