APPS.MSC_RELEASE_PK dependencies on DUAL

Line 515: from dual;

511: errbuf := NULL;
512:
513: select decode(FND_PROFILE.VALUE('MSC_DRP_RELEASE_FROM_MRP'),'Y',SYS_YES,SYS_NO)
514: into lv_plan_release_profile
515: from dual;
516:
517: var_debug := FND_PROFILE.VALUE('MRP_DEBUG') = 'Y';
518:
519: SELECT ALLOW_RELEASE_FLAG,

Line 596: FROM dual;

592: FND_GLOBAL.APPLICATION_NAME
593: INTO var_user_name,
594: var_resp_name,
595: var_application_name
596: FROM dual;
597:
598: var_sql_stmt:=
599: 'BEGIN'
600: ||' MRP_AP_REL_PLAN_PUB.INITIALIZE'||var_dblink

Line 621: ||' FROM DUAL';

617: var_sql_stmt:=
618: 'SELECT FND_GLOBAL.USER_ID,'
619: ||' FND_PROFILE.VALUE'||var_dblink||'(''WIP_JOB_PREFIX''),'
620: ||' FND_PROFILE.VALUE'||var_dblink||'(''MRP_LOAD_REQ_GROUP_BY'')'
621: ||' FROM DUAL';
622:
623: EXECUTE IMMEDIATE var_sql_stmt INTO var_user_id,
624: var_default_job_prefix,
625: var_po_group_by;

Line 675: FROM DUAL '

671:
672: begin
673: -- populating batch_id from destination side seq.
674: Execute immediate 'select mrp_workbench_query_s.nextval
675: FROM DUAL '
676: into MSC_Rel_Plan_PUB.g_batch_id;
677: exception when others then
678: fnd_file.put_line(FND_FILE.LOG, sqlerrm);
679: end;

Line 909: 'SELECT wip_job_number_s.nextval'||var_dblink||' FROM dual';

905: IF(var_order_type=PLANNED_ORDER)
906: /*discrete job reschedules don't require new name*/
907: THEN
908: var_sql_stmt:=
909: 'SELECT wip_job_number_s.nextval'||var_dblink||' FROM dual';
910:
911: EXECUTE IMMEDIATE var_sql_stmt
912: INTO var_wip_job_number;
913: END IF;