APPS.CSL_JTF_TASKS_ACC_PKG dependencies on ASG_USER

Line 562: , ASG_USER au

558: CURSOR c_task( b_task_id NUMBER ) IS
559: SELECT tk.SOURCE_OBJECT_TYPE_CODE
560: , au.RESOURCE_ID
561: FROM JTF_TASKS_B tk
562: , ASG_USER au
563: WHERE tk.TASK_ID = b_task_id
564: AND tk.CREATED_BY = au.USER_ID;
565: r_task c_task%ROWTYPE;
566: l_enabled_flag VARCHAR2(30);

Line 897: , ASG_USER au

893:
894: CURSOR c_task( b_resource_id NUMBER ) IS
895: SELECT tk.task_id
896: FROM JTF_TASKS_B tk
897: , ASG_USER au
898: WHERE tk.SOURCE_OBJECT_TYPE_CODE = 'SR'
899: AND tk.CREATED_BY = au.USER_ID
900: AND au.RESOURCE_ID = b_resource_id;
901: r_task c_task%ROWTYPE;