APPS.EAM_SETNAME_PUB dependencies on DUAL

Line 183: SELECT EAM_PM_SET_NAMES_S.NEXTVAL INTO L_SET_NAME_ID FROM DUAL;

179:
180:
181: /* End validation calls */
182:
183: SELECT EAM_PM_SET_NAMES_S.NEXTVAL INTO L_SET_NAME_ID FROM DUAL;
184:
185: X_NEW_SET_NAME_ID := L_SET_NAME_ID;
186:
187: INSERT INTO eam_pm_set_names

Line 502: select 'Y' into l_exists from dual

498:
499: if nvl(l_local_flag, 'N') = 'N' then
500:
501: begin
502: select 'Y' into l_exists from dual
503: where exists
504: (
505: select eps.*
506: from eam_pm_schedulings eps, csi_item_instances cii, mtl_parameters mp

Line 676: dual

672:
673: SELECT
674: 'PASS' into l_status
675: FROM
676: dual
677: WHERE
678: p_end_date > sysdate;
679:
680: IF (l_status = 'PASS') THEN