Item Overhead Cost

SELECT :P_ORG_CODE,
  crd.resources,
  gms.calendar_code,
  gms.period_code,
  mthd.cost_mthd_code ,
  crd.nominal_cost
FROM CM_RSRC_DTL crd,
  mtl_parameters mp,
  gmf_period_statuses gms,
  gmf_calendar_assignments gca,
  cm_mthd_mst mthd
WHERE crd.organization_id= mp.organization_id
  AND gca.cost_type_id            = mthd.cost_type_id
AND mp.organization_code = :P_ORG_CODE
    AND crd.legal_entity_id         = gca.legal_entity_id
        AND gca.calendar_code           = gms.calendar_code
AND gms.period_id        =crd.period_id
AND gms.legal_entity_id  =crd.legal_entity_id
AND gms.period_code      = TO_CHAR(to_date(:P_PERIOD,'MON-YY'), 'MMYY') ;