DBA Data[Home] [Help]

APPS.CSM_TASKS_PKG dependencies on ASG_USER

Line 49: FROM ASG_USER

45:
46: --Bug 5288413
47: CURSOR c_res_id (b_user_name VARCHAR2) IS
48: SELECT RESOURCE_ID
49: FROM ASG_USER
50: WHERE USER_NAME=b_user_name;
51:
52: CURSOR c_csm_appl IS
53: SELECT APPLICATION_ID

Line 60: FROM ASG_USER

56:
57: CURSOR c_csm_resp(c_user_id NUMBER)
58: IS
59: SELECT RESPONSIBILITY_ID
60: FROM ASG_USER
61: WHERE USER_ID = c_user_id;
62:
63: -- Declare OUT parameters
64: l_msg_count NUMBER;