DBA Data[Home] [Help]

APPS.EDR_UTILITIES dependencies on EDR_ESIGNATURES

Line 463: DELETE EDR_ESIGNATURES where EVENT_ID not in (SELECT EVENT_ID from EDR_ERECORDS);

459: fnd_message.set_name('EDR', 'EDR_UTIL_PLS_CLEAN_EREC');
460: fnd_message.set_token( 'CLN_NUMREC', SQL%ROWCOUNT);
461: fnd_file.put_line(fnd_file.output, fnd_message.get);
462:
463: DELETE EDR_ESIGNATURES where EVENT_ID not in (SELECT EVENT_ID from EDR_ERECORDS);
464:
465: fnd_message.set_name('EDR', 'EDR_UTIL_PLS_CLEAN_ESIG');
466: fnd_message.set_token( 'CLN_NUMSIG', SQL%ROWCOUNT);
467: fnd_file.put_line(fnd_file.output, fnd_message.get);

Line 624: from EDR_ESIGNATURES A,

620: --Bug 4113995: Start
621: --Including overriding comments in the cursor.
622: SIGNATURE_OVERRIDING_COMMENTS
623: --Bug 4113995: End
624: from EDR_ESIGNATURES A,
625: FND_LOOKUPS B,
626: WF_LOOKUPS C
627: WHERE EVENT_ID=to_number(document_id,'999999999999.999999' ) AND
628: A.SIGNATURE_STATUS=B.LOOKUP_CODE AND