APPS.BEN_EXTRACT_SEED dependencies on PAY_EVENT_GROUPS

Line 558: from pay_event_groups

554: and trunc(sysdate) between nvl(start_date_active, trunc(sysdate))
555: and nvl(end_date_active, trunc(sysdate)) ;
556:
557: cursor cep is select event_group_name
558: from pay_event_groups
559: where event_group_id = p_val
560: ;
561:
562: cursor cx is select user_name

Line 1323: from pay_event_groups

1319: and trunc(sysdate) between nvl(start_date_active, trunc(sysdate))
1320: and nvl(end_date_active, trunc(sysdate))
1321: ;
1322: cursor cep is select event_group_id
1323: from pay_event_groups
1324: where event_group_name = p_meaning
1325: and nvl(business_group_id,nvl(p_business_group_id,-1))
1326: = nvl(p_business_group_id,-1)
1327: ;

Line 4667: from pay_event_groups

4663:
4664: l_return varchar2(250) ;
4665:
4666: cursor cep is select event_group_name
4667: from pay_event_groups
4668: where event_group_id = p_CHG_EVT_CD
4669:
4670: ;
4671:

Line 4699: from pay_event_groups

4695:
4696: l_return varchar2(250) ;
4697:
4698: cursor cep is select event_group_id
4699: from pay_event_groups
4700: where event_group_name = P_CHG_EVT_CD
4701: and nvl(business_group_id,nvl(p_business_group_id,-1))
4702: = nvl(p_business_group_id,-1)
4703: ;