DBA Data[Home] [Help]

APPS.QA_RESULT_GRP dependencies on EDR_PSIG_DOCUMENTS

Line 457: l_event_key EDR_PSIG_DOCUMENTS.event_key%TYPE;

453: l_api_version CONSTANT NUMBER := 1.0;
454:
455: ctr NUMBER := 1;
456: l_prev_plan_id NUMBER := -1;
457: l_event_key EDR_PSIG_DOCUMENTS.event_key%TYPE;
458:
459: -- Get all occurrences for a collection
460: -- Bug 5508639. SHKALYAN 13-Sep-2006.
461: -- Process only Results which are in disabled status.

Line 493: FROM EDR_PSIG_DOCUMENTS

489: CURSOR get_erecords( c_event_key VARCHAR2 )
490: IS
491: SELECT event_name,
492: document_id
493: FROM EDR_PSIG_DOCUMENTS
494: WHERE event_key = c_event_key
495: AND event_name IN
496: ( 'oracle.apps.qa.ncm.create',
497: 'oracle.apps.qa.ncm.update',