APPS.GMD_API_PUB SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 147

SELECT f.application_id, f.responsibility_id, f.responsibility_name
FROM   fnd_responsibility_vl f, fnd_application a
WHERE  f.application_id = a.application_id
AND    a.application_short_name = 'GMD'
AND    SYSDATE between f.start_date and NVL(f.end_date,SYSDATE)
AND    f.RESPONSIBILITY_KEY =  'GMD_QUALITY_MANAGER' -- Bug 3837330
ORDER  BY f.responsibility_id;