APPS.CSF_MAINTAIN_GRP dependencies on CSP_REQ_LINE_DETAILS

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

384: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'CSF', 'In CSF_MAINTAIN_GRP.Purge_FieldServiceObjects() deleted FS task debrief header details ');
385: END IF;
386:
387: /* Step 4 - Delete relevant requirement line details */
388: DELETE /*+ index(crld) */ FROM CSP_REQ_LINE_DETAILS crld
389: WHERE
390: req_line_detail_id in
391: (
392: SELECT /*+ no_unnest no_semijoin cardinality(10) */

Line 395: CSP_REQ_LINE_DETAILS csprdt

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