APPS.CSF_MAINTAIN_GRP dependencies on CSP_REQUIREMENT_HEADERS

Line 368: , CSP_REQUIREMENT_HEADERS csprh

364: csprdt.req_line_detail_id
365: FROM
366: CSP_REQ_LINE_DETAILS csprdt
367: , CSP_REQUIREMENT_LINES csprl
368: , CSP_REQUIREMENT_HEADERS csprh
369: , JTF_TASKS_B tskt
370: , JTF_OBJECT_PURGE_PARAM_TMP tmp
371: WHERE
372: tmp.PROCESSING_SET_ID = P_PROCESSING_SET_ID and

Line 391: , CSP_REQUIREMENT_HEADERS csprh

387: SELECT /*+ cardinality(TMP, 10) */
388: csprl.requirement_line_id
389: FROM
390: CSP_REQUIREMENT_LINES csprl
391: , CSP_REQUIREMENT_HEADERS csprh
392: , JTF_TASKS_B tskt
393: , JTF_OBJECT_PURGE_PARAM_TMP tmp
394: WHERE
395: tmp.PROCESSING_SET_ID = P_PROCESSING_SET_ID and

Line 406: DELETE /*+ index(crh) */ FROM CSP_REQUIREMENT_HEADERS crh

402:
403:
404:
405: /* Step 6 - Delete relevant requirement headers */
406: DELETE /*+ index(crh) */ FROM CSP_REQUIREMENT_HEADERS crh
407: WHERE
408: requirement_header_id in
409: (
410: SELECT /*+ cardinality(TMP, 10) */

Line 413: CSP_REQUIREMENT_HEADERS csprh

409: (
410: SELECT /*+ cardinality(TMP, 10) */
411: csprh.requirement_header_id
412: FROM
413: CSP_REQUIREMENT_HEADERS csprh
414: , JTF_TASKS_B tskt
415: , JTF_OBJECT_PURGE_PARAM_TMP tmp
416: WHERE
417: tmp.PROCESSING_SET_ID = P_PROCESSING_SET_ID and