DBA Data[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 304: csp_requirement_headers hdr,

300: p_user_id IN NUMBER)
301: IS
302: SELECT line.requirement_line_id
303: FROM jtf_task_assignments jta,
304: csp_requirement_headers hdr,
305: csp_requirement_lines line,
306: asg_user au
307: WHERE jta.task_assignment_id = p_task_assg_id
308: AND hdr.task_id = jta.task_id

Line 1342: csp_requirement_headers hdr

1338: IS
1339: SELECT hdr.requirement_header_id,
1340: jta.resource_id
1341: FROM jtf_task_assignments jta,
1342: csp_requirement_headers hdr
1343: WHERE jta.task_assignment_id = p_task_assg_id
1344: AND hdr.task_id = jta.task_id
1345: AND EXISTS
1346: (SELECT 1

Line 1394: csp_requirement_headers hdr,

1390: SELECT line.requirement_line_id,
1391: line.requirement_header_id,
1392: acc.user_id
1393: FROM jtf_task_assignments jta,
1394: csp_requirement_headers hdr,
1395: csp_requirement_lines line,
1396: csm_req_lines_acc acc
1397: WHERE jta.task_assignment_id = p_task_assg_id
1398: AND hdr.task_id = jta.task_id