APPS.MSC_RELEASE_PK dependencies on DUAL

Line 635: from dual;

631: where plan_id = arg_plan_id ;
632:
633: select decode(FND_PROFILE.VALUE('MSC_DRP_RELEASE_FROM_MRP'),'Y',SYS_YES,SYS_NO)
634: into lv_plan_release_profile
635: from dual;
636:
637: var_debug := FND_PROFILE.VALUE('MRP_DEBUG') = 'Y';
638:
639: SELECT ALLOW_RELEASE_FLAG,

Line 743: FROM dual;

739: FND_GLOBAL.APPLICATION_NAME
740: INTO var_user_name,
741: var_resp_name,
742: var_application_name
743: FROM dual;
744:
745: var_sql_stmt:=
746: 'BEGIN'
747: ||' MRP_AP_REL_PLAN_PUB.INITIALIZE'||var_dblink

Line 768: ||' FROM DUAL';

764: var_sql_stmt:=
765: 'SELECT FND_GLOBAL.USER_ID,'
766: ||' FND_PROFILE.VALUE'||var_dblink||'(''WIP_JOB_PREFIX''),'
767: ||' FND_PROFILE.VALUE'||var_dblink||'(''MRP_LOAD_REQ_GROUP_BY'')'
768: ||' FROM DUAL';
769:
770: EXECUTE IMMEDIATE var_sql_stmt INTO var_user_id,
771: var_default_job_prefix,
772: var_po_group_by;

Line 827: FROM DUAL '

823:
824: begin
825: -- populating batch_id from destination side seq.
826: Execute immediate 'select mrp_workbench_query_s.nextval
827: FROM DUAL '
828: into MSC_Rel_Plan_PUB.g_batch_id;
829: exception when others then
830: fnd_file.put_line(FND_FILE.LOG, sqlerrm);
831: end;

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

1101: IF(var_order_type=PLANNED_ORDER)
1102: /*discrete job reschedules don't require new name*/
1103: THEN
1104: var_sql_stmt:=
1105: 'SELECT wip_job_number_s.nextval'||var_dblink||' FROM dual';
1106:
1107: EXECUTE IMMEDIATE var_sql_stmt
1108: INTO var_wip_job_number;
1109: END IF;