APPS.CSF_MAINTAIN_GRP dependencies on CSP_REQ_LINE_DETAILS

Line 359: DELETE /*+ index(crld) */ FROM CSP_REQ_LINE_DETAILS crld

355: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'CSF', 'In CSF_MAINTAIN_GRP.Purge_FieldServiceObjects() deleted FS task debrief header details ');
356: END IF;
357:
358: /* Step 4 - Delete relevant requirement line details */
359: DELETE /*+ index(crld) */ FROM CSP_REQ_LINE_DETAILS crld
360: WHERE
361: req_line_detail_id in
362: (
363: SELECT /*+ cardinality(TMP, 10) */

Line 366: CSP_REQ_LINE_DETAILS csprdt

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