DBA Data[Home] [Help]

APPS.CSM_TASK_ASSIGNMENTS_PKG dependencies on CSF_M_DEBRIEF_PARTS_INQ

Line 270: CSF_M_DEBRIEF_PARTS_INQ inq

266: CURSOR c_get_debrief_parts(c_task_assg_id NUMBER,c_user_id NUMBER,c_user_name VARCHAR2)
267: IS
268: SELECT ACCESS_ID,INQ.DEBRIEF_LINE_ID,INQ.TRANID$$,INQ.SEQNO$$
269: FROM CSM_DEBRIEF_LINES_ACC acc,
270: CSF_M_DEBRIEF_PARTS_INQ inq
271: WHERE acc.USER_ID(+) = c_user_id
272: AND inq.TASK_ASSIGNMENT_ID = c_task_assg_id
273: AND inq.DEBRIEF_LINE_ID = acc.DEBRIEF_LINE_ID(+)
274: AND inq.CLID$$CS = c_user_name;