DBA Data[Home] [Help]

APPS.CSM_TASK_ASSIGNMENTS_PKG dependencies on CSM_DEBRIEF_LINES_ACC

Line 249: FROM CSM_DEBRIEF_LINES_ACC acc,

245:
246: CURSOR c_get_debrief_expenses(c_task_assg_id NUMBER,c_user_id NUMBER,c_user_name VARCHAR2)
247: IS
248: SELECT ACCESS_ID,INQ.DEBRIEF_LINE_ID,INQ.TRANID$$,INQ.SEQNO$$
249: FROM CSM_DEBRIEF_LINES_ACC acc,
250: CSF_M_DEBRIEF_EXPENSES_INQ inq
251: WHERE acc.USER_ID(+) = c_user_id
252: AND inq.TASK_ASSIGNMENT_ID = c_task_assg_id
253: AND inq.DEBRIEF_LINE_ID = acc.DEBRIEF_LINE_ID(+)

Line 259: FROM CSM_DEBRIEF_LINES_ACC acc,

255:
256: CURSOR c_get_debrief_labor(c_task_assg_id NUMBER,c_user_id NUMBER,c_user_name VARCHAR2)
257: IS
258: SELECT ACCESS_ID,INQ.DEBRIEF_LINE_ID,INQ.TRANID$$,INQ.SEQNO$$
259: FROM CSM_DEBRIEF_LINES_ACC acc,
260: CSF_M_DEBRIEF_LABOR_INQ inq
261: WHERE acc.USER_ID(+) = c_user_id
262: AND inq.TASK_ASSIGNMENT_ID = c_task_assg_id
263: AND inq.DEBRIEF_LINE_ID = acc.DEBRIEF_LINE_ID(+)

Line 269: FROM CSM_DEBRIEF_LINES_ACC acc,

265:
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(+)