APPS.MSC_REL_PS_PLAN_PUB dependencies on DUAL

Line 246: FROM dual;

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

Line 855: FROM dual;

851:
852: SELECT decode(nvl(FND_PROFILE.value('MSC_RELEASE_DTLS_REVDATE'),'Y'),'N',2,1),
853: DECODE(NVL(fnd_profile.value('MSC_INFLATE_WIP') ,'N'), 'N',2 ,1)
854: INTO lv_release_details,lv_inflate_wip
855: FROM dual;
856:
857:
858: /* we release the lot based job details, only if it doesn't use aggregate resources */
859:

Line 2644: FROM dual;

2640:
2641: SELECT decode(nvl(FND_PROFILE.value('MSC_RELEASE_DTLS_REVDATE'),'Y'),'N',2,1),
2642: DECODE(NVL(fnd_profile.value('MSC_INFLATE_WIP') ,'N'), 'N',2 ,1)
2643: INTO lv_release_details,lv_inflate_wip
2644: FROM dual;
2645:
2646: /* we release the discrete job, only if it doesn't use aggregate resources */
2647: /* bug 1252659 fix, replace rowid by
2648: (transaction_id,sr_instance_id,plan_id) */