APPS.GMD_QMSMC dependencies on FND_APPLICATION

Line 440: FROM fnd_application

436:
437: CURSOR get_application_id
438: IS /* 4576699 */
439: SELECT application_id
440: FROM fnd_application
441: WHERE application_short_name = 'GMD';
442:
443: CURSOR get_user_name (x_user_id NUMBER)
444: IS /* 4576699 */

Line 1570: /* Get application_id from FND_APPLICATION */

1566: END IF;
1567:
1568:
1569: /* Get First Approver */
1570: /* Get application_id from FND_APPLICATION */
1571: -- Bug 4576699: Added cursor instead of 'select' statement here
1572: OPEN get_application_id; /* xxx4576699 */
1573:
1574: FETCH get_application_id INTO l_application_id;

Line 1839: /* Get application_id from FND_APPLICATION */

1835: l_log varchar2(4000);
1836: BEGIN
1837:
1838: /* Get Next Approver */
1839: /* Get application_id from FND_APPLICATION */
1840: select application_id into l_application_id
1841: from fnd_application where application_short_name='GMD';
1842:
1843: AME_API.GETNEXTAPPROVER(applicationIdIn => l_application_id,

Line 1841: from fnd_application where application_short_name='GMD';

1837:
1838: /* Get Next Approver */
1839: /* Get application_id from FND_APPLICATION */
1840: select application_id into l_application_id
1841: from fnd_application where application_short_name='GMD';
1842:
1843: AME_API.GETNEXTAPPROVER(applicationIdIn => l_application_id,
1844: transactionIdIn => l_event_key,
1845: transactionTypeIn => l_transaction_type,

Line 2183: /* Get application_id from FND_APPLICATION */

2179: FETCH get_from_role into l_from_role ;
2180: CLOSE get_from_role ;
2181:
2182: IF P_FUNCMODE='RUN' THEN
2183: /* Get application_id from FND_APPLICATION */
2184: SELECT application_id INTO l_application_id
2185: FROM fnd_application
2186: WHERE application_short_name='GMD';
2187:

Line 2185: FROM fnd_application

2181:
2182: IF P_FUNCMODE='RUN' THEN
2183: /* Get application_id from FND_APPLICATION */
2184: SELECT application_id INTO l_application_id
2185: FROM fnd_application
2186: WHERE application_short_name='GMD';
2187:
2188: /*************************************/
2189: /* Check which event has been raised */