APPS.CSF_MAINTAIN_GRP dependencies on CSP_REQUIREMENT_HEADERS

Line 397: , CSP_REQUIREMENT_HEADERS csprh

393: csprdt.req_line_detail_id
394: FROM
395: CSP_REQ_LINE_DETAILS csprdt
396: , CSP_REQUIREMENT_LINES csprl
397: , CSP_REQUIREMENT_HEADERS csprh
398: , JTF_TASKS_B tskt
399: , JTF_OBJECT_PURGE_PARAM_TMP tmp
400: WHERE
401: tmp.PROCESSING_SET_ID = P_PROCESSING_SET_ID and

Line 420: , CSP_REQUIREMENT_HEADERS csprh

416: SELECT /*+ no_unnest no_semijoin cardinality(10) */
417: csprl.requirement_line_id
418: FROM
419: CSP_REQUIREMENT_LINES csprl
420: , CSP_REQUIREMENT_HEADERS csprh
421: , JTF_TASKS_B tskt
422: , JTF_OBJECT_PURGE_PARAM_TMP tmp
423: WHERE
424: tmp.PROCESSING_SET_ID = P_PROCESSING_SET_ID and

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

431:
432:
433:
434: /* Step 6 - Delete relevant requirement headers */
435: DELETE /*+ index(crh) */ FROM CSP_REQUIREMENT_HEADERS crh
436: WHERE
437: requirement_header_id in
438: (
439: SELECT /*+ no_unnest no_semijoin cardinality(10) */

Line 442: CSP_REQUIREMENT_HEADERS csprh

438: (
439: SELECT /*+ no_unnest no_semijoin cardinality(10) */
440: csprh.requirement_header_id
441: FROM
442: CSP_REQUIREMENT_HEADERS csprh
443: , JTF_TASKS_B tskt
444: , JTF_OBJECT_PURGE_PARAM_TMP tmp
445: WHERE
446: tmp.PROCESSING_SET_ID = P_PROCESSING_SET_ID and