APPS.CSM_DEBRIEF_PARTS_PKG dependencies on ASG_USER

Line 26: SELECT USER_ID,RESPONSIBILITY_ID,APP_ID FROM asg_user WHERE user_name = b_user;

22: AND clid$$cs = b_user_name;
23:
24: CURSOR c_csm_user_details(b_user VARCHAR2)
25: is
26: SELECT USER_ID,RESPONSIBILITY_ID,APP_ID FROM asg_user WHERE user_name = b_user;
27:
28: CURSOR c_get_item_id(c_item_name VARCHAR2, c_org_id NUMBER)
29: IS
30: SELECT INVENTORY_ITEM_ID,MATERIAL_BILLABLE_FLAG,PRIMARY_UOM_CODE