341: AND lookup_code=l_sample_source;
342:
343: l_log:='Resolved Lookups';
344: /* Get First Approver */
345: /* Get application_id from FND_APPLICATION */
346: select application_id into l_application_id
347: from fnd_application where application_short_name='GMD';
348:
349: IF (l_debug = 'Y') THEN
343: l_log:='Resolved Lookups';
344: /* Get First Approver */
345: /* Get application_id from FND_APPLICATION */
346: select application_id into l_application_id
347: from fnd_application where application_short_name='GMD';
348:
349: IF (l_debug = 'Y') THEN
350: gmd_debug.put_line('Ckecking approvers ');
351: END IF;
515:
516:
517:
518: /* Get Next Approver */
519: /* Get application_id from FND_APPLICATION */
520: select application_id into l_application_id
521: from fnd_application where application_short_name='GMD';
522:
523: ame_api.getNextApprover(applicationIdIn => l_application_id,
517:
518: /* Get Next Approver */
519: /* Get application_id from FND_APPLICATION */
520: select application_id into l_application_id
521: from fnd_application where application_short_name='GMD';
522:
523: ame_api.getNextApprover(applicationIdIn => l_application_id,
524: transactionIdIn => l_event_key,
525: transactionTypeIn => l_transaction_type,