DBA Data[Home] [Help]

APPS.CSM_UNDO_PKG dependencies on CSM_DEBRIEF_LINES_ACC

Line 113: FROM CSM_DEBRIEF_LINES_ACC acc,

109:
110: CURSOR c_get_debrief_expenses(c_task_assg_id NUMBER,c_user_id NUMBER,c_user_name VARCHAR2)
111: IS
112: SELECT ACCESS_ID,INQ.DEBRIEF_LINE_ID,INQ.TRANID$$,INQ.SEQNO$$
113: FROM CSM_DEBRIEF_LINES_ACC acc,
114: CSF_M_DEBRIEF_EXPENSES_INQ inq
115: WHERE acc.USER_ID(+) = c_user_id
116: AND inq.TASK_ASSIGNMENT_ID = c_task_assg_id
117: AND inq.DEBRIEF_LINE_ID = acc.DEBRIEF_LINE_ID(+)

Line 123: FROM CSM_DEBRIEF_LINES_ACC acc,

119:
120: CURSOR c_get_debrief_labor(c_task_assg_id NUMBER,c_user_id NUMBER,c_user_name VARCHAR2)
121: IS
122: SELECT ACCESS_ID,INQ.DEBRIEF_LINE_ID,INQ.TRANID$$,INQ.SEQNO$$
123: FROM CSM_DEBRIEF_LINES_ACC acc,
124: CSF_M_DEBRIEF_LABOR_INQ inq
125: WHERE acc.USER_ID(+) = c_user_id
126: AND inq.TASK_ASSIGNMENT_ID = c_task_assg_id
127: AND inq.DEBRIEF_LINE_ID = acc.DEBRIEF_LINE_ID(+)

Line 133: FROM CSM_DEBRIEF_LINES_ACC acc,

129:
130: CURSOR c_get_debrief_parts(c_task_assg_id NUMBER,c_user_id NUMBER,c_user_name VARCHAR2)
131: IS
132: SELECT ACCESS_ID,INQ.DEBRIEF_LINE_ID,INQ.TRANID$$,INQ.SEQNO$$
133: FROM CSM_DEBRIEF_LINES_ACC acc,
134: CSF_M_DEBRIEF_PARTS_INQ inq
135: WHERE acc.USER_ID(+) = c_user_id
136: AND inq.TASK_ASSIGNMENT_ID = c_task_assg_id
137: AND inq.DEBRIEF_LINE_ID = acc.DEBRIEF_LINE_ID(+)