APPS.CSF_MAINTAIN_GRP dependencies on CSP_REQUIREMENT_LINES

Line 367: , CSP_REQUIREMENT_LINES csprl

363: SELECT /*+ cardinality(TMP, 10) */
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

Line 383: DELETE /*+ index(crl) */ FROM CSP_REQUIREMENT_LINES crl

379: );
380:
381:
382: /* Step 5 - Delete relevant requirement lines */
383: DELETE /*+ index(crl) */ FROM CSP_REQUIREMENT_LINES crl
384: WHERE
385: requirement_line_id in
386: (
387: SELECT /*+ cardinality(TMP, 10) */

Line 390: CSP_REQUIREMENT_LINES csprl

386: (
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