DBA Data[Home] [Help]

APPS.MSC_GET_PROFILE dependencies on FND_APPLICATION

Line 196: select application_id into appl_id from fnd_application where application_short_name=application_name;

192: select user_id into usr_id from fnd_user where user_name=usr_name;
193: END IF;
194:
195: IF application_name is NOT NULL THEN
196: select application_id into appl_id from fnd_application where application_short_name=application_name;
197: END IF;
198:
199: IF resp_name is NOT NULL THEN
200: select responsibility_id into resp_id from fnd_responsibility_vl where responsibility_name=resp_name and application_id=appl_id;