DBA Data[Home] [Help]

APPS.EGO_PUB_WS_UTIL dependencies on FND_RESPONSIBILITY

Line 598: FROM FND_RESPONSIBILITY

594:
595: --retrieving responsibility name
596: SELECT responsibility_key
597: INTO l_responsibility_name
598: FROM FND_RESPONSIBILITY
599: WHERE responsibility_id = l_responsibility_id;
600:
601: /*INSERT INTO tr_temp (Session_id, message)
602: values (p_session_id, 'RESPONSIBILITY_NAME:' || l_responsibility_name);*/

Line 625: FROM FND_RESPONSIBILITY

621:
622: --retrieving application_id
623: SELECT application_id
624: INTO l_application_id
625: FROM FND_RESPONSIBILITY
626: WHERE responsibility_id = l_responsibility_id;
627:
628: --retrieving responsibility_appl_name
629: SELECT APPLICATION_SHORT_NAME

Line 698: FROM FND_RESPONSIBILITY

694:
695: --retrieving responsibility id from responsibility name
696: SELECT RESPONSIBILITY_ID
697: INTO x_resp_id
698: FROM FND_RESPONSIBILITY
699: WHERE RESPONSIBILITY_KEY = p_resp_name;
700:
701: RETURN TRUE;
702: