[Home] [Help]
1117: AND gps.start_date <= p_date
1118: AND gps.end_date >= p_date
1119: AND gps.period_id = cst.period_id
1120: AND cst.organization_id = (SELECT NVL (cstw.cost_organization_id, invw.organization_id)
1121: FROM cm_whse_asc cstw, mtl_parameters invw
1122: WHERE cstw.organization_id(+) = invw.organization_id
1123: AND invw.organization_id = p_orgn_id
1124: AND NVL(cstw.eff_start_date,p_date) <= p_date
1125: AND NVL(cstw.eff_end_date,p_date) >= p_date
1154: AND cst.cost_type_id = p_cost_type_id
1155: AND gps.period_id = cst.period_id
1156: AND cst.organization_id =
1157: (SELECT NVL (cstw.cost_organization_id, invw.organization_id)
1158: FROM cm_whse_asc cstw, mtl_parameters invw
1159: WHERE cstw.organization_id(+) = invw.organization_id
1160: AND invw.organization_id = p_orgn_id
1161: AND NVL(cstw.eff_start_date,p_date) <= p_date
1162: AND NVL(cstw.eff_end_date,p_date) >= p_date