APPS.MRP_SELECT_ALL_FOR_RELEASE_PUB dependencies on DUAL

Line 416: FROM DUAL;

412: l_cursor INTEGER;
413:
414: CURSOR GET_QUERY_ID IS
415: SELECT MRP_FORM_QUERY_S.NEXTVAL
416: FROM DUAL;
417: BEGIN
418:
419: l_where_clause := p_where_clause;
420:

Line 479: FROM DUAL;

475: l_cursor INTEGER;
476:
477: CURSOR GET_QUERY_ID IS
478: SELECT MRP_FORM_QUERY_S.NEXTVAL
479: FROM DUAL;
480: BEGIN
481:
482: l_where_clause := p_where_clause;
483:

Line 582: select userenv('SESSIONID') into l_session_id from dual;

578: l_demand_class := p_demand_class;
579: l_def_job_class := p_def_job_class;
580: l_def_firm_jobs := p_def_firm_jobs;
581:
582: select userenv('SESSIONID') into l_session_id from dual;
583:
584: /*-------------------------------------------------------------+
585: | Update implement as attribute for planned orders. |
586: +--------------------------------------------------------------*/

Line 1659: select userenv('SESSIONID') into l_session_id from dual;

1655: BEGIN
1656:
1657: l_wip_job_prefix := FND_PROFILE.VALUE('WIP_JOB_PREFIX');
1658:
1659: select userenv('SESSIONID') into l_session_id from dual;
1660:
1661: update mrp_recommendations mr set
1662: implement_job_name = l_wip_job_prefix||to_char(wip_job_number_s.nextval)
1663: where implement_job_name=to_char(l_session_id)