APPS.GMF_PROCESS_COST_PUB SQL Statements

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

Line: 39

    SELECT gps.end_date
      FROM gmf_period_statuses gps
     WHERE end_date < p_end_date
       AND legal_entity_id = p_le_id
       AND cost_type_id    = p_ct_id
    ORDER BY end_date desc
  ;

Line: 68

  SELECT gfp.legal_entity_id,
         gfp.cost_type_id,
         mthd.cost_type
  INTO   l_le_id,
         l_cost_type_id,
         l_cost_type
  FROM   gmf_fiscal_policies gfp,
         cm_mthd_mst mthd,
         org_organization_definitions ood,
         mtl_parameters mp
  WHERE  gfp.cost_type_id = mthd.cost_type_id
       AND gfp.legal_entity_id = ood.legal_entity
       AND ood.organization_id = p_organization_id
       AND mp.organization_id = p_organization_id
       AND mp.process_enabled_flag = 'Y'
       AND mthd.delete_mark = 0
       AND gfp.delete_mark  = 0
       ;