APPS.XTR_STREAMLINE_P dependencies on XTR_REVALUATION_DETAILS

Line 30: from xtr_revaluation_details

26: and batch_type is null; -- 3527080 exclude NRA batch
27:
28: cursor c_incomplete is
29: select 'Y'
30: from xtr_revaluation_details
31: where batch_id = l_batch_id
32: and company_code = p_company
33: and nvl(complete_flag,'N') = 'N';
34:

Line 578: xtr_revaluation_details a

574:
575: cursor UPGRADE_REQUIRED is
576: SELECT 'Y'
577: FROM xtr_batches b,
578: xtr_revaluation_details a
579: WHERE b.company_code = p_company
580: AND b.batch_id = a.batch_id
581: AND NVL(b.upgrade_batch,'N') = 'Y'
582: AND b.batch_type is null -- 3527080 exclude NRA batch