eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

APPS.CSM_TASK_ASSIGNMENT_EVENT_PKG dependencies on CSP_REQUIREMENT_HEADERS

Line 255: csp_requirement_headers hdr

251: IS
252: SELECT hdr.requirement_header_id,
253: jta.resource_id
254: FROM jtf_task_assignments jta,
255: csp_requirement_headers hdr
256: WHERE jta.task_assignment_id = p_task_assg_id
257: AND hdr.task_id = jta.task_id
258: AND NOT EXISTS
259: (SELECT 1

Line 306: csp_requirement_headers hdr,

302: SELECT line.requirement_line_id,
303: line.requirement_header_id,
304: jta.resource_id
305: FROM jtf_task_assignments jta,
306: csp_requirement_headers hdr,
307: csp_requirement_lines line
308: WHERE jta.task_assignment_id = p_task_assg_id
309: AND hdr.task_id = jta.task_id
310: AND line.requirement_header_id = hdr.requirement_header_id

Line 1274: csp_requirement_headers hdr

1270: IS
1271: SELECT hdr.requirement_header_id,
1272: jta.resource_id
1273: FROM jtf_task_assignments jta,
1274: csp_requirement_headers hdr
1275: WHERE jta.task_assignment_id = p_task_assg_id
1276: AND hdr.task_id = jta.task_id
1277: AND EXISTS
1278: (SELECT 1

Line 1326: csp_requirement_headers hdr,

1322: SELECT line.requirement_line_id,
1323: line.requirement_header_id,
1324: acc.user_id
1325: FROM jtf_task_assignments jta,
1326: csp_requirement_headers hdr,
1327: csp_requirement_lines line,
1328: csm_req_lines_acc acc
1329: WHERE jta.task_assignment_id = p_task_assg_id
1330: AND hdr.task_id = jta.task_id