APPS.GMF_BATCH_VALIDATIONS SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 43

 SELECT min(trans_date), max(trans_date) from
 (SELECT t.transaction_date trans_date
   FROM gme_batch_header h, mtl_material_transactions t
  WHERE h.batch_id = p_batch_id
    AND h.organization_id = t.organization_id
    AND h.batch_id = t.transaction_source_id
    AND t.transaction_source_type_id = 5
  UNION
   SELECT rt.trans_date
	FROM gme_batch_header h, gme_resource_txns rt
	WHERE h.batch_id = p_batch_id
	AND    h.batch_id = rt.doc_id
	AND    rt.completed_ind = 1
	AND    rt.doc_type = 'PROD') txn;

Line: 59

 SELECT gps.period_id
   FROM gmf_period_statuses gps, gmf_organization_definitions god, gmf_fiscal_policies gfp,
        gme_batch_header gbh, gmf_calendar_assignments gca
  WHERE gbh.batch_id = p_batch_id
    AND gbh.organization_id   = god.organization_id
    AND god.legal_entity_id   = gfp.legal_entity_id
    AND gfp.delete_mark       = 0
    AND gfp.cost_type_id      = gps.cost_type_id
    AND gfp.cost_type_id      = gca.cost_type_id
    AND god.legal_entity_id   = gca.legal_entity_id
    AND gca.calendar_code     = gps.calendar_code
    AND gps.start_date       <= p_date
    AND gps.end_date         >= p_date;