APPS.ARI_SELF_REGISTRATION_PKG dependencies on DUAL

Line 1053: from dual

1049: BEGIN
1050:
1051: select 'Y'
1052: into l_return
1053: from dual
1054: where p_user_id IN ( select user_id
1055: from umx_role_assignments_v
1056: where role_name like 'UMX|ARI_CUST_ADMIN');
1057:

Line 2725: SELECT UMX_REG_REQUESTS_S.nextval INTO l_item_key FROM dual;

2721: l_event.setParameterList(l_parameter_list);
2722:
2723: FND_PROFILE.Get('OIR_APPROVAL_FOR_ACCOUNT_ACCESS', l_approval_profile);
2724: l_event_name := 'oracle.apps.ar.irec.addcustaccess';
2725: SELECT UMX_REG_REQUESTS_S.nextval INTO l_item_key FROM dual;
2726:
2727: IF (l_approval_profile='Y') THEN
2728:
2729: WF_ENGINE.CREATEPROCESS('ARIADDAC',

Line 2847: SELECT UMX_REG_REQUESTS_S.nextval INTO l_event_key FROM dual;

2843:
2844: /*------------------------------------------------------------------+
2845: | Set the Person_party_id |
2846: +------------------------------------------------------------------*/
2847: SELECT UMX_REG_REQUESTS_S.nextval INTO l_event_key FROM dual;
2848: WF_ENGINE.SetItemAttrText('ARIADDAC',
2849: l_item_key,
2850: 'EVENT_KEY',
2851: l_event_key);