APPS.CSF_MAINTAIN_GRP dependencies on CSP_REQUIREMENT_LINES

Line 396: , CSP_REQUIREMENT_LINES csprl

392: SELECT /*+ no_unnest no_semijoin cardinality(10) */
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

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

408: );
409:
410:
411: /* Step 5 - Delete relevant requirement lines */
412: DELETE /*+ index(crl) */ FROM CSP_REQUIREMENT_LINES crl
413: WHERE
414: requirement_line_id in
415: (
416: SELECT /*+ no_unnest no_semijoin cardinality(10) */

Line 419: CSP_REQUIREMENT_LINES csprl

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