APPS.MSC_REL_PS_PLAN_PUB dependencies on DUAL

Line 247: FROM dual;

243: l_user_name,
244: l_resp_name,
245: l_application_name,
246: l_application_id
247: FROM dual;
248:
249: -------- Release the planned order one instance by one instance.
250:
251: OPEN c_Instance;

Line 881: FROM dual;

877:
878: SELECT decode(nvl(FND_PROFILE.value('MSC_RELEASE_DTLS_REVDATE'),'Y'),'N',2,1),
879: DECODE(NVL(fnd_profile.value('MSC_INFLATE_WIP') ,'N'), 'N',2 ,1)
880: INTO lv_release_details,lv_inflate_wip
881: FROM dual;
882:
883:
884: /* we release the lot based job details, only if it doesn't use aggregate resources */
885:

Line 2671: FROM dual;

2667:
2668: SELECT decode(nvl(FND_PROFILE.value('MSC_RELEASE_DTLS_REVDATE'),'Y'),'N',2,1),
2669: DECODE(NVL(fnd_profile.value('MSC_INFLATE_WIP') ,'N'), 'N',2 ,1)
2670: INTO lv_release_details,lv_inflate_wip
2671: FROM dual;
2672:
2673: /* we release the discrete job, only if it doesn't use aggregate resources */
2674: /* bug 1252659 fix, replace rowid by
2675: (transaction_id,sr_instance_id,plan_id) */